Index

A B C D E F G H I J K L M N O P Q R S T U V W X Y

Symbols

arithmetic operator negative, 4.1.2

arithmetic operator subtraction, 4.1.2

relation deletion, 1.1.1.3

(+)

outer join operator, 12.2

arithmetic operator multiply, 4.1.2

maximal pattern quantifier (0 or more times), 15.7

used with count function, 6.1

used with select clause, 16.1

minimal pattern quantifier (0 or more times), 15.7

arithmetic operator addition, 4.1.2

arithmetic operator positive, 4.1.2

maximal pattern quantifier (1 or more times), 15.7

relation insertion, 1.1.1.3

minimal pattern quantifier (1 or more times), 15.7

maximal pattern quantifier (0 or 1 time), 15.7

minimal pattern quantifier (0 or 1 time), 15.7

concatenation operator, 4.1.2

A

ABS function, 9.1

ABS1 function, 9.1

ABS2 function, 9.1

ABS3 function, 9.1

ACOS function, 9.1

aggr_distinct_expr syntax, 11.1

aggr_expr syntax, 11.1

aggregate expressions, 11.1, 11.1

aggregate functions, 6

AggregationFunctionFactory, 10.2.2

aliases

about, 2.8

columns, 2.8.1

stream elements, 2.8.1

window operators, 2.8.2

ALL MATCHES clause

about, 15.2

partial overlapping patterns, 15.2

total overlapping patterns, 15.2

ALL operator, 12.2

AND condition, 12.3, 12.3

ANY operator, 12.2

API

AggregationFunctionFactory, 10.2.2

SingleElementFunction, 10.2.1

application time, 1.1.10

application timestamped, 1.1.10

application-timestamped, 1.1.10

arguments of operators, 4

arith_expr syntax, 11.1

arith_expr_list syntax, 11.1

alias operator, 2.8, 2.8.2

correlation_name_definition syntax, 15.3

measure_column syntax, 15.5

as operator, 2.8.1

asc_desc syntax, 16.1

ASIN function, 9.1

ATAN function, 9.1

ATAN2 function, 9.1

attr

clause, 13.1

syntax, 13.1

attrspec

clause, 13.1

syntax, 13.1

AUTOCORRELATION function, 8.1.1

AVG function, 6.1

B

base relation, 1.1.1.2

base stream, 1.1.1.2

BETA function, 7.1

BETA1 function, 7.1

BETACOMPLEMENTED function, 7.1

between conditions, 12.5

between_condition syntax, 12.5

BIGINT, 2.2.1

binary

clause, 16.1

syntax, 16.1

binary operators, 4.1.1

BINOMIAL function, 7.1

BINOMIAL1 function, 7.1

BINOMIAL2 function, 7.1

BINOMIALCOMPLEMENTED function, 7.1

BITMASKWITHBITSSETFROMTO function, 7.1

BOOLEAN, 2.2.1

built-in datatypes, 2.2.1

built-in functions

about, 1.1.9

aggregate

about, 6

distinct, 6.1

nested, 6.1

Colt, 1.1.9, 1.1.9, 7, 8

java.lang.Math, 1.1.9, 9

single-row

about, 5

built-in windows

about, 1.1.3

queries, 14.2.3

builtin_aggr syntax, 6.1

builtin_aggr_incr syntax, 6.1

BYTE, 2.2.1

C

cache, 1.1.8.1

Oracle CQL queries, 14.5

Oracle CQL user-defined functions, 10.1.3

case_expr syntax, 11.1

CBRT function, 9.1

CDATA, 1.2.1

CEIL function, 7.1

CEIL1 function, 9.1

CEP Service Engine. See Oracle CEP Service Engine

CEP_DDL

use, 1.2.1

channels

query selector, 1.1.1.1

stream, 1.1.1.1

CHAR, 2.2.1

character sets and multibyte characters, 2.9.1

CHISQUARE function, 7.1

CHISQUARECOMPLEMENTED function, 7.1

classpath

Oracle CEP Service Engine, 10.1, 10.2.1, 10.2.2

single-row user-defined functions, 10.2.1, 10.2.2

user-defined functions, 10.1

Colt built-in functions, 1.1.9, 1.1.9, 7, 8

column aliases, 2.8.1

comments

CQL, 1.2.1, 2.7

XML, 5.1

comparison conditions

(+) outer join operator, 12.2

about, 12.2

simple, 12.2

comparison rules

character values, 2.3.3

datatypes, 2.3

date value, 2.3.2

compound conditions, 12.7

compound_conditions syntax, 12.7

CONCAT function, 5.1

concatenation operator, 4.1.2, 5.1

condition syntax, 12.2

conditions

about, 12

between, 12.5

comparison

(+) outer join operator, 12.2

about, 12.2

simple, 12.2

compound, 12.7

compound_conditions syntax, 12.7

in, 12.8

logical

about, 12.3

AND, 12.3

NOT, 12.3

OR, 12.3

XOR, 12.3

nulls, 2.6.2, 12.6

pattern-matching

LIKE, 12.4

LK function, 5.1

precedence, 12.1.1

range, 12.5

const_bigint

clause, 13.1

syntax, 13.1

const_int

clause, 13.1

syntax, 13.1

const_string

clause, 13.1

quotation marks, 2.4.1

syntax, 13.1

text literals, 2.4.1

const_value

syntax, 13.1

constraints

out-of-line, 13.1

content, 11.1

Continuous Query Language. See CQL

conversion, 2.3.4

CORRELATION function, 8.1.1

correlation_name syntax, 15.7

correlation_name_definition syntax, 15.3

COS function, 9.1

COSH function, 9.1

COUNT function, 6.1

COVARIANCE function, 8.1.1

CQL

alias, 2.8

basic elements, 2

comments, 1.2.1, 2.7

conditions, 12

.cqlx files, 1.2.1

datatype comparison rules, 2.3

datatypes, 2.2

expressions, 11

format models, 2.5

joins, 14

lexical conventions, 1.2.1

literals, 2.4

MATCH_RECOGNIZE, 15

naming rules, 2.9.1

nulls

about, 2.6

in comparison conditions, 2.6.2

in functions, 2.6.1

operators, 4

Oracle tools support of, 1.4

pattern recognition

about, 1.1.7, 15

pseudocolumns

about, 3

attr clause, 13.1

ELEMENT_TIME, 3.2

queries, 14

statements, 16

syntax, 1.2.2

views, 14

CQL statements

[REGISTER | CREATE] VIEW identifier, 16.1

about, 1.2, 16

attr clause, 13.1

attrspec clause, 13.1

binary clause, 16.1

const_bigint clause, 13.1

const_int clause, 13.1

const_string clause, 13.1

EXCEPT, 16.1

identifier clause, 13.1

IN and NOT IN, 16.1

INTERSECT, 16.1

lexical conventions, 1.2.1

MINUS, 16.1

non_mt_arg_list clause, 13.1

non_mt_attr_list clause, 13.1

non_mt_attrname_list clause, 13.1

non_mt_attrspec_list clause, 13.1

non_mt_cond_list clause, 13.1

out_of_line_constraint

clause, 13.1

query, 16.1

query_ref clause, 13.1

relation_variable, 16.1

set, 16.1

syntax conventions, 1.2.2

time_spec clause, 13.1

UNION and UNION ALL, 16.1

update semantics, 13.1, 16.1

xml_attr_list clause, 13.1

xml_attribute_list clause, 13.1

xqryargs_list clause, 13.1

.cqlx files

CDATA, 1.2.1

CEP_DDL use, 1.2.1

lexical conventions, 1.2.1

rules, 1.2.1

statement terminator, 1.2.1

CREATE VIEW identifier, 16.1

D

data destinations

about, 1.1.8, 1.1.8.2

data sources

cache, 1.1.8.1, 1.1.8.1

relational database table, 1.1.8.1

table, 1.1.8.1

datatype syntax, 2.2

datatypes

about, 2.2

BIGINT, 2.2.1

BOOLEAN, 2.2.1

built-in, 2.2.1

BYTE, 2.2.1

CHAR, 2.2.1

comparison rules, 2.3.1

about, 2.3

character values, 2.3.3

conversion

about, 2.3.4

explicit, 2.3.4.2

implicit, 2.3.4.1

user-defined functions, 2.3.4.3, 10.1.2

date value comparison rules, 2.3.2

DOUBLE, 2.2.1

enum, 2.2.2

evaluating with functions, 2.2.2

FLOAT, 2.2.1

format models

about, 2.5

datetime, 2.5.2, 5.1

number, 2.5.1

INTEGER, 2.2.1

INTERVAL, 2.2.1

literals

about, 2.4

float, 2.4.2.2

integer, 2.4.2.1

interval, 2.4.4

interval day to second, 2.4.4.1

text, 2.4.1

timestamp, 2.4.3

mapping in user-defined functions, 10.1.2

other, 2.2.2

TIMESTAMP, 2.2.1

unsupported, 2.2.2

user-defined functions, 10.1.2

XMLTYPE, 2.2.1

datetime literals

about, 2.4.3

xsd

dateTime, 2.4.3

day, 13.1

days, 13.1

DDL

[REGISTER | CREATE] VIEW identifier, 16.1

query, 16.1

decimal characters, 2.4.2.2

decode

in arithmetic expressions, 11.1

nulls, 2.6.2

decode syntax, 11.1

DEFINE clause

about, 15.3

correlation names, 15.3

derived stream, 1.1.1.2, 1.1.1.2

distinct

aggregate expressions, 11.1

built-in aggregate functions, 6.1

function expressions, 11.1

relations, 1.1.2

select_clause, 16.1

document, 11.1

DOUBLE, 2.2.1

double quotes, 2.4.1

DStream relation-to-stream operator, 4.1.2

DURATION clause, 15.4

DURATION MULTIPLES OF clause, 15.4

duration_clause syntax, 15.4

DURBINWATSON function, 8.1.1, 8.1.1

E

Eclipse, 1.4.2

enum datatypes, 2.2.2

equality test, 12.2

equivalency tests, 12.8

ERRORFUNCTION function, 7.1

ERRORFUNCTIONCOMPLEMENTED function, 7.1

event sinks

about, 1.1.8, 1.1.8.2

event sources

about, 1.1.8, 1.1.8.1

cacge, 1.1.8.1

cache, 1.1.8.1

pull, 1.1.8.1

push, 1.1.8.1

relational database table, 1.1.8.1

table, 1.1.8.1

events

non-event detection, 15.9

EXCEPT clause, 16.1

EXP function, 9.1

EXPM1 function, 9.1

expressions

about, 11

aggr_distinct_expr, 11.1

aggr_expr, 11.1

aggregate, 11.1, 11.1

aggregate distinct, 11.1

arith_expr, 11.1

arith_expr_list, 11.1

arithmetic, 11.1, 11.1

case, 11.1

case_expr, 11.1

decode, 11.1, 11.1

func_expr, 11.1

function, 11.1, 11.1, 11.1, 11.1, 11.1

order, 11.1

order_expr, 11.1

xml_agg_expr, 11.1

xml_parse_expr, 11.1

xmlcolattval_expr, 11.1

xmlelement_expr, 11.1

xmlforest_expr, 11.1

extended_builtin_aggr syntax, 6.1

F

FACTORIAL function, 7.1

FIRST function, 6.1

fixed_length_datatype syntax, 2.2

FLOAT, 2.2.1

FLOOR function, 7.1

FLOOR1 function, 9.1

format models

about, 2.5

datetime, 2.5.2, 5.1

number, 2.5.1

from_clause syntax, 14.2.1.3, 16.1

func_expr syntax, 11.1

functions

ABS, 9.1

ABS1, 9.1

ABS2, 9.1

ABS3, 9.1

ACOS, 9.1

ASIN, 9.1

ATAN, 9.1

ATAN2, 9.1

AUTOCORRELATION, 8.1.1

AVG, 6.1

BETA, 7.1

BETA1, 7.1

BETACOMPLEMENTED, 7.1

BINOMIAL, 7.1

BINOMIAL1, 7.1

BINOMIAL2, 7.1

BINOMIALCOMPLEMENTED, 7.1

BITMASKWITHBITSSETFROMTO, 7.1

CBRT, 9.1

CEIL, 7.1

CEIL1, 9.1

CHISQUARE, 7.1

CHISQUARECOMPLEMENTED, 7.1

CONCAT, 5.1

CORRELATION, 8.1.1

COS, 9.1

COSH, 9.1

COUNT, 6.1

COVARIANCE, 8.1.1

DURBINWATSON, 8.1.1, 8.1.1

ERRORFUNCTION, 7.1

ERRORFUNCTIONCOMPLEMENTED, 7.1

EXP, 9.1

EXPM1, 9.1

FACTORIAL, 7.1

FIRST, 6.1

FLOOR, 7.1

FLOOR1, 9.1

GAMMA, 7.1

GAMMA1, 7.1

GAMMACOMPLEMENTED, 7.1

GEOMETRICMEAN, 8.1.1

GETSEEDATROWCOLUMN, 7.1

HARMONICMEAN, 8.1.1

HASH, 7.1

HASH1, 7.1

HASH2, 7.1

HASH3, 7.1

HEXTORAW, 5.1

HYPOT, 9.1

I0, 7.1

I0E, 7.1

I1, 7.1

I1E, 7.1

IEEEREMAINDER, 9.1

INCOMPLETEBETA, 7.1

INCOMPLETEGAMMA, 7.1

INCOMPLETEGAMMACOMPLEMENT, 7.1

J0, 7.1

J1, 7.1

JN, 7.1

K0, 7.1

K0E, 7.1

K1, 7.1

K1E, 7.1

KN, 7.1

KURTOSIS, 8.1.1

LAG1, 8.1.1

LAST, 6.1

LEASTSIGNIFICANTBIT, 7.1

LENGTH, 5.1

LK, 5.1

LOG, 7.1

LOG1, 9.1

LOG10, 7.1

LOG101, 9.1

LOG1P, 9.1

LOG2, 7.1

LOGFACTORIAL, 7.1

LOGGAMMA, 7.1

LONGFACTORIAL, 7.1

MAX, 6.1

MEAN, 8.1.1

MEANDEVIATION, 8.1.1

MEDIAN, 8.1.1

MIN, 6.1

MOMENT, 8.1.1, 8.1.1, 8.1.1

MOSTSIGNIFICANTBIT, 7.1

NEGATIVEBINOMIAL, 7.1

NEGATIVEBINOMIALCOMPLEMENTED, 7.1

NORMAL, 7.1

NORMAL1, 7.1

NORMALINVERSE, 7.1

NVL, 5.1

POISSON, 7.1

POISSONCOMPLEMENTED, 7.1

POW, 9.1

PREV, 5.1

PRODUCT, 8.1.1

QUANTILE, 8.1.1

QUANTILEINVERSE, 8.1.1

RANKINTERPOLATED, 8.1.1

RAWTOHEX, 5.1

RINT, 9.1

RMS, 8.1.1

ROUND, 9.1

ROUND1, 9.1

SAMPLEKURTOSIS, 8.1.1

SAMPLEKURTOSISSTANDARDERROR, 8.1.1

SAMPLESKEW, 8.1.1

SAMPLESKEWSTANDARDERROR, 8.1.1

SAMPLESTANDARDDEVIATION, 8.1.1

SAMPLEVARIANCE, 8.1.1

SIGNUM, 9.1

SIGNUM1, 9.1

SIN, 9.1

SINH, 9.1

SKEW, 8.1.1

SQRT, 9.1

STANDARDDEVIATION, 8.1.1

STANDARDERROR, 8.1.1

STIRLINGCORRECTION, 7.1

STUDENTT, 7.1

STUDENTTINVERSE, 7.1

SUM, 6.1

SUMOFINVERSIONS, 8.1.1

SUMOFLOGARITHMS, 8.1.1

SUMOFPOWERDEVIATIONS, 8.1.1

SUMOFPOWERS, 8.1.1

SUMOFSQUAREDDEVIATIONS, 8.1.1

SUMOFSQUARES, 8.1.1

SYSTIMESTAMP, 5.1

TAN, 9.1

TANH, 9.1

TO_BIGINT, 5.1

TO_BOOLEAN, 5.1

TO_CHAR, 5.1

TO_DOUBLE, 5.1

TO_FLOAT, 5.1

TO_TIMESTAMP, 5.1

TODEGREES, 9.1

TORADIANS, 9.1

TRIMMEDMEAN, 8.1.1

ULP, 9.1

ULP1, 9.1

VARIANCE, 8.1.1

WEIGHTEDMEAN, 8.1.1

WINSORIZEDMEAN, 8.1.1

XMLAGG, 6.1

XMLCOMMENT, 5.1

XMLCONCAT, 5.1

XMLEXISTS, 5.1

XMLQUERY, 5.1

Y0, 7.1

Y1, 7.1

YN, 7.1

functions about

AggregationFunctionFactory, 10.2.2

categories, 1.1.9

datatype mapping, 10.1.2

distinct and aggregate built-in functions, 6.1

java.lang.Math, 1.1.9

naming rules, 1.1.9, 2.9.1, 10.1.1

nested aggregates, 6.1

nulls, 2.6.1

overloading, 1.1.9, 2.9.1, 10.1.1

overriding, 1.1.9, 2.9.1, 10.1.1

SingleElementFunction, 10.2.1

single-row built-in, 1.1.9

user-defined, 1.1.9

G

GAMMA function, 7.1

GAMMA1 function, 7.1

GAMMACOMPLEMENTED function, 7.1

GEOMETRICMEAN function, 8.1.1

GETSEEDATROWCOLUMN function, 7.1

greater than or equal to tests, 12.2

greater than tests, 12.2

group by

GROUP BY clause, 16.1

PARTITION BY clause, 15.6

partitioned window, 4.1.2, 4.1.2, 4.1.2

H

HARMONICMEAN function, 8.1.1

HASH function, 7.1

HASH1 function, 7.1

HASH2 function, 7.1

HASH3 function, 7.1

HAVING clause, 16.1

heartbeat

system timestamped relations, 1.1.10

system timestamped streams, 1.1.10

HEXTORAW function, 5.1

hour, 13.1

hours, 13.1

HYPOT function, 9.1

I

I0 function, 7.1

I0E function, 7.1

I1 function, 7.1

I1E function, 7.1

identifier

clause, 13.1

syntax, 13.1

IEEEREMAINDER function, 9.1

IN clause, 16.1

in conditions, 12.8

in_condition syntax, 12.8

INCLUDE TIMER EVENTS clause, 15.1

INCOMPLETEBETA function, 7.1

INCOMPLETEGAMMA function, 7.1

INCOMPLETEGAMMACOMPLEMENT function, 7.1

incremental computation

about, 10.1.1

implementing, 10.2.2

run-time behavior, 10.2.2

inequality test, 12.2

inner joins, 14.4.1

INTEGER, 2.2.1

integer syntax, 2.4.2.1

integers

in CQL syntax, 2.4.2.1

precision of, 2.4.2.1

INTERSECT clause, 16.1

INTERVAL, 2.2.1

interval_value syntax, 2.4.4.1, 13.1

IS NOT NULL condition, 12.6

IS NULL condition, 12.6

is-silent-relation, 1.1.1.3

is-total-order, 1.1.10

IStream relation-to-stream operator, 4.1.2

J

J0 function, 7.1

J1 function, 7.1

java.lang.Math built-in functions, 9

JN function, 7.1

joins

(+) outer join operator, 12.2, 14.4.2

about, 14, 14.4

inner, 14.4.1

outer, 14.4.2

self joins, 14.4.2.3

simple, 14.4.1

K

K0 function, 7.1

K0E function, 7.1

K1 function, 7.1

K1E function, 7.1

keywords in object names, 2.9.1, 13.1, 13.1

KN function, 7.1

KURTOSIS function, 8.1.1

L

LAG1 function, 8.1.1

LAST function, 6.1

LEASTSIGNIFICANTBIT function, 7.1

LENGTH function, 5.1

length of names, 2.9.1

less than tests, 12.2

lexical conventions

about, 1.2.1

.cqlx files, 1.2.1

general, 1.2.1

LIKE condition, 5.1, 12.4

like_condition syntax, 12.4

literals, 2.4

LK function, 5.1

locale

decimal characters, 2.4.2.2

nonquoted identifiers, 2.9.1

ORDER BY, 14.2.6

RAWTOHEX, 5.1

text literals, 2.4.1

LOG function, 7.1

LOG1 function, 9.1

LOG10 function, 7.1

LOG101 function, 9.1

LOG1P function, 9.1

LOG2 function, 7.1

LOGFACTORIAL function, 7.1

LOGGAMMA function, 7.1

logical conditions, 12.3

AND, 12.3

NOT, 12.3

OR, 12.3

XOR, 12.3

LONGFACTORIAL function, 7.1

M

MATCH_RECOGNIZE

about, 15

ALL MATCHES clause

about, 15.2

partial overlapping patterns, 15.2

total overlapping patterns, 15.2

DEFINE clause, 15.3

DURATION clause, 15.4

DURATION MULTIPLES OF clause, 15.4

examples

non-event detection, 15.9

pattern detection, 15.9

pattern detection with aggregates, 15.9

pattern detection with partition by, 15.9

INCLUDE TIMER EVENTS clause, 15.1

MEASURES clause, 15.5

PARTITION BY clause, 15.6

PATTERN clause

about, 15.7

default, 15.7

queries, 14.2.4

SUBSET clause, 15.8

MAX function, 6.1

MEAN function, 8.1.1

MEANDEVIATION function, 8.1.1

measure_column syntax, 15.5

MEASURES clause, 15.5

MEDIAN function, 8.1.1

millisecond, 13.1

milliseconds, 13.1

MIN function, 6.1

MINUS clause, 16.1

minute, 13.1

minutes, 13.1

MOMENT function, 8.1.1, 8.1.1, 8.1.1

MOSTSIGNIFICANTBIT function, 7.1

multibyte characters, 2.9.1

N

naming rules

about, 2.9.1

length, 2.9.1

NaN, 6.1

nanosecond, 13.1

nanoseconds, 13.1

NEGATIVEBINOMIAL function, 7.1

NEGATIVEBINOMIALCOMPLEMENTED function, 7.1

non_mt_arg_list

clause, 13.1

syntax, 13.1

non_mt_arg_list_set syntax, 13.1

non_mt_attr_list

clause, 13.1

syntax, 13.1

non_mt_attrname_list

clause, 13.1

syntax, 13.1

non_mt_attrspec_list

clause, 13.1

syntax, 13.1

non_mt_cond_list

clause, 13.1

syntax, 13.1

non_mt_corr_list syntax, 15.8

non_mt_corrname_definition_list syntax, 15.3

non_mt_measure_list syntax, 15.5

non_mt_projterm_list syntax, 16.1

non_mt_relation_list syntax, 16.1

non_mt_subset_definition_list syntax, 15.8

nonequivalency tests, 12.8

non-event detection, 15.9

non-events, 15.9

NORMAL function, 7.1

NORMAL1 function, 7.1

NORMALINVERSE function, 7.1

NOT condition, 12.3, 12.3

NOT IN clause, 16.1

null_conditions syntax, 12.6

null_spec syntax, 16.1

nulls

about, 2.6

conditions, 12.6

decode, 2.6.2

in conditions, 2.6.3, 2.6.3

in functions, 2.6.1

IS NOT NULL condition, 12.6

IS NULL condition, 12.6

NVL function, 5.1

value conversion, 5.1

with comparison conditions, 2.6.2

number precision, 2.4.2.2

number syntax, 2.4.2.2

numeric literals

NaN, 6.1

numeric values

about, 2.3.1

comparison rules, 2.3.1

NVL function, 5.1

O

object names and keywords, 2.9.1, 13.1, 13.1

operands, 4

operations

relation-to-stream, 1.1.4

stream-to-relation, 1.1.3

stream-to-stream, 1.1.5

operators, 4

arithmetic, 4.1.2

binary, 4.1.1

concatenation, 4.1.2, 5.1, 5.1

precedence, 4.1.2

relation-to-stream

DStream, 4.1.2

IStream, 4.1.2

RStream, 4.1.2

stream-to-relation

partitioned S[Partition By A1 ... Ak Rows N Range T], 4.1.2

partitioned S[Partition By A1 ... Ak Rows N Range T1 Slide T2], 4.1.2

partitioned S[Partition By A1 ... Ak Rows N], 4.1.2

S[Now] time-based, 4.1.2

S[Range C on E] constant value-based, 4.1.2

S[Range T] time-based, 4.1.2

S[Range T1 Slide T2] time-based, 4.1.2

S[Range Unbounded] time-based, 4.1.2

S[Rows N] tuple-based, 4.1.2

S[Rows N1 slide N2] tuple-based, 4.1.2

unary, 4.1.1

opt_group_by_clause syntax, 16.1

opt_having_clause syntax, 16.1

opt_where_clause syntax, 16.1

OR condition, 12.3, 12.3

Oracle CEP Service Engine

about, 1.1

Oracle tools

about, 1.4

support of CQL, 1.4

ORDER BY

order by top, 16.1

rows, 16.1

ORDER BY clause

about, 16.1, 16.1

of SELECT, 14.2.6

ORDER BY ROWS clause, 16.1

order_by_clause syntax, 14.2.6, 16.1

order_by_list syntax, 16.1

order_by_top_clause syntax, 16.1

order_expr syntax, 11.1

orderterm syntax, 16.1

out_of_line_constraint clause, 13.1

out_of_line_constraint syntax, 13.1

outer joins, 14.4.2

overlapping patterns

partial, 15.2

total, 15.2

overloading functions, 1.1.9, 2.9.1, 10.1.1

overriding

functions, 1.1.9, 2.9.1, 10.1.1

P

partial overlapping patterns, 15.2

partition by

rows, 4.1.2

rows and range, 4.1.2

rows, range, and slide, 4.1.2

window specification, 1.1.3

PARTITION BY clause, 15.6

PATTERN clause

about, 15.7

default, 15.7

pattern recognition

about, 1.1.7, 15

pattern_clause syntax, 15.7

pattern_def_dur_clause syntax, 15.1

pattern_definition_clause syntax, 15.3

pattern_measures_clause syntax, 15.5

pattern_partition_clause syntax, 15.6

pattern_quantifier syntax, 15.7

pattern_recognition_clause syntax, 15.1

pattern_skip_match_clause syntax, 15.2

pattern-matching conditions

LIKE, 12.4

LK function, 5.1

POISSON function, 7.1

POISSONCOMPLEMENTED function, 7.1

POW function, 9.1

precedence

operators, 4.1.2

precision and number of digits of, 2.4.2.2

PREV function, 5.1

PRODUCT function, 8.1.1

projterm syntax, 16.1

pseudo_column syntax, 13.1

pseudocoloumns

about, 3

attr clause, 13.1

ELEMENT_TIME, 3.2

pull event sources, 1.1.8.1

push event sources, 1.1.8.1

Q

QUANTILE function, 8.1.1

QUANTILEINVERSE function, 8.1.1

queries

about, 14, 14.2

built-in windows, 14.2.3

cache, 14.5

MATCH_RECOGNIZE, 14.2.4

ORDER_BY, 14.2.6

simple, 14.2.2

sorting, 14.2.6

subqueries, 1.1.6, 14.1

views, 14.3

XMLTABLE, 14.2.5

query, 16.1

query syntax, 14.2, 16.1

query_ref

clause, 13.1

syntax, 13.1

quotation marks

about, 2.4.1

locale, 2.9.1

text literals, 2.4.1

quoted_string_double_quotes syntax, 13.1

quoted_string_single_quotes syntax, 13.1

R

range

conditions, 12.5

window specification, 1.1.3

RANKINTERPOLATED function, 8.1.1

RAWTOHEX function, 5.1

regexp syntax, 15.7

registerquery syntax, 14.2

registerview syntax, 14.3

relation_variable syntax, 14.2.1.3, 16.1

relational database tables, 1.1.8.1

relations

about, 1.1.1.2

base, 1.1.1.2

distinct, 1.1.2

heartbeat, 1.1.10

operation indicator

deletion (-), 1.1.1.3

insertion (+), 1.1.1.3

update (U), 1.1.1.3

schema, 1.1.1.2

tuple kind indicator, 1.1.1.3

relation-to-stream operators, 1.1.4

DStream, 4.1.2

IStream, 4.1.2

RStream, 4.1.2

reserved words, 2.9.1, 2.9.1, 13.1

RINT function, 9.1

RMS function, 8.1.1

ROUND function, 9.1

ROUND1 function, 9.1

RStream relation-to-stream operator, 4.1.2

S

SAMPLEKURTOSIS function, 8.1.1

SAMPLEKURTOSISSTANDARDERROR function, 8.1.1

SAMPLESKEW function, 8.1.1

SAMPLESKEWSTANDARDERROR function, 8.1.1

SAMPLESTANDARDDEVIATION function, 8.1.1

SAMPLEVARIANCE function, 8.1.1

scheduler

time, 1.1.10

schema

relation, 1.1.1.2

stream, 1.1.1.1, 1.1.1.1

schema objects

naming

examples, 2.9.3

guidelines, 2.9.2

searched_case syntax, 11.1

searched_case_list syntax, 11.1

second, 13.1

seconds, 13.1

select_clause

distinct, 16.1

syntax, 14.2.1.2, 16.1

self joins, 14.4.2.3

set statements

about, 16.1

EXCEPT, 16.1

IN and NOT IN, 16.1

INTERSECT, 16.1

MINUS, 16.1

UNION and UNION ALL, 16.1

sfw_block syntax, 14.2.1.1, 16.1

SIGNUM function, 9.1

SIGNUM1 function, 9.1

silent, 1.1.1.3

simple comparison conditions, 12.2

simple joins, 14.4.1

simple queries, 14.2.2

simple_case syntax, 11.1

simple_case_list syntax, 11.1

SIN function, 9.1

single quotes, 2.4.1

SingleElementFunction, 10.2.1

SINH function, 9.1

SKEW function, 8.1.1

slide window specification, 1.1.3

SOME operator, 12.2

sorting query results, 14.2.6

SQL99, 1.3

SQLX

about, 11.1

content, 11.1

document, 11.1

expressions, 11.1

func_expr, 11.1

functions, 5.1

wellformed, 11.1

xml_agg_expr, 11.1

xml_parse_expr, 11.1

XMLAGG function, 6.1

xmlcolattval_expr, 11.1

XMLCONCAT function, 5.1

xmlelement_expr, 11.1

XMLEXISTS function, 5.1

xmlforest_expr, 11.1

XMLQUERY function, 5.1

SQL/XML. See SQLX

SQRT function, 9.1

STANDARDDEVIATION function, 8.1.1

STANDARDERROR function, 8.1.1

standards, 1.3

statement terminator, 1.2.1

STIRLINGCORRECTION function, 7.1

streams

about, 1.1.1.1

base, 1.1.1.2

channel, 1.1.1.1

derived, 1.1.1.2, 1.1.1.2

heartbeat, 1.1.10

query selector, 1.1.1.1

relation, 1.1.1.2, 1.1.1.2

schema, 1.1.1.1, 1.1.1.1

tuple, 1.1.1.1

stream-to-relation operators, 1.1.3

group by, 4.1.2, 4.1.2, 4.1.2

partitioned S[Partition By A1 ... Ak Rows N Range T], 4.1.2

partitioned S[Partition By A1 ... Ak Rows N Range T1 Slide T2], 4.1.2

partitioned S[Partition By A1 ... Ak Rows N], 4.1.2

S[Now] time-based, 4.1.2

S[Range C on E] constant value-based, 4.1.2

S[Range T] time-based, 4.1.2

S[Range T1 Slide T2] time-based, 4.1.2

S[Range Unbounded] time-based, 4.1.2

S[Rows N] tuple-based, 4.1.2

S[Rows N1 slide N2] tuple-based, 4.1.2

stream-to-stream operators, 1.1.5

filter, 1.1.5

MATCH_RECOGNIZE, 1.1.5

project, 1.1.5

XMLTABLE, 1.1.5

STUDENTT function, 7.1

STUDENTTINVERSE function, 7.1

subqueries, 1.1.6, 1.1.6, 14.1

SUBSET clause, 15.8

subset_clause

about, 15.8

syntax, 15.8

subset_definition syntax, 15.8

subset_name syntax, 15.8

SUM function, 6.1

SUMOFINVERSIONS function, 8.1.1

SUMOFLOGARITHMS function, 8.1.1

SUMOFPOWERDEVIATIONS function, 8.1.1

SUMOFPOWERS function, 8.1.1

SUMOFSQUAREDDEVIATIONS function, 8.1.1

SUMOFSQUARES function, 8.1.1

system time, 1.1.10

system timestamped, 1.1.10

SYSTIMESTAMP function, 5.1

T

tables, 1.1.8.1

TAN function, 9.1

TANH function, 9.1

terminator, 1.2.1

text literals

about, 2.4.1

quotation marks, 2.4.1

time

about, 1.1.10

application, 1.1.10

application timestamped, 1.1.10

heartbeat, 1.1.10

is-total-order, 1.1.10

scheduler, 1.1.10

system, 1.1.10

system timestamped, 1.1.10

time_spec

clause, 13.1

syntax, 13.1

time_unit

syntax, 13.1

TIMESTAMP, 2.2.1

about, 2.4.3

xsd

dateTime, 2.4.3

timestamps

application, 1.1.10

system, 1.1.10

TO_BIGINT function, 5.1

TO_BOOLEAN function, 5.1

TO_CHAR function, 5.1

TO_DOUBLE function, 5.1

TO_FLOAT function, 5.1

TO_TIMESTAMP function, 5.1

TODEGREES function, 9.1

tools support

development, 1.4.2

Oracle CEP IDE for Eclipse, 1.4.2

Oracle CEP Server, 1.4.1

Oracle CEP Visualizer, 1.4.1

runtime, 1.4.1

TORADIANS function, 9.1

total overlapping patterns, 15.2

TRIMMEDMEAN function, 8.1.1

tuple

about, 1.1.1.1

kind indicator, 1.1.1.3

streams, 1.1.1.1

U

relation update, 1.1.1.3

ULP function, 9.1

ULP1 function, 9.1

unary operators, 4.1.1

UNION ALL clause, 16.1

UNION clause, 16.1

unreserved words, 13.1

unreserved_keyword syntax, 13.1

update semantics

named query, 16.1

relation, 13.1

user-defined functions

about, 1.1.9, 10

cache, 10.1.3

classpath, 10.2.1, 10.2.2

datatype mapping, 10.1.2

implementing, 10.1, 10.2

aggregate, 10.2.2

AggrFunctionImpl, 10.2.2

SingleElementFunction, 10.2.1

single-row, 10.2.1

incremental computation

about, 10.1.1

implementing, 10.2.2

run-time behavior, 10.2.2

types of, 10.1.1

V

variable_length_datatype syntax, 2.2

VARIANCE function, 8.1.1

view_description syntax, 14.3

views

about, 14

queries, 14.3

W

WEIGHTEDMEAN function, 8.1.1

wellformed, 11.1

window_type syntax, 1.1.3, 16.1

window_type_partition syntax, 4.1.2

window_type_range syntax, 4.1.2

window_type_tuple syntax, 4.1.2

windows, 1.1.3

about, 1.1.3

Now, 4.1.2

partitioned, 1.1.3, 4.1.2, 4.1.2, 4.1.2

range specification, 1.1.3

S[Now] time-based, 4.1.2

S[Partition By A1 ... Ak Rows N Range T], 4.1.2

S[Partition By A1 ... Ak Rows N Range T1 Slide T2], 4.1.2

S[Partition By A1 ... Ak Rows N], 4.1.2

S[Range C on E] constant value-based, 4.1.2

S[Range T] time-based, 4.1.2

S[Range T1 Slide T2] time-based, 4.1.2

S[Range Unbounded] time-based, 4.1.2

S[Rows N] tuple-based, 4.1.2

S[Rows N1 slide N2] tuple-based, 4.1.2

slide specification, 1.1.3

Unbounded, 4.1.2

WINSORIZEDMEAN function, 8.1.1

X

xml_agg_expr syntax, 11.1

xml_attr syntax, 13.1

xml_attr_list

clause, 13.1

syntax, 13.1

xml_attribute_list

clause, 13.1

syntax, 13.1

XMLAGG function, 6.1

xmlcolattval_expr syntax, 11.1, 11.1

XMLCOMMENT function, 5.1

XMLCONCAT function, 5.1

XMLEXISTS function, 5.1

xmlforest_expr syntax, 11.1, 11.1

XMLQUERY function, 5.1

XMLTABLE queries, 14.2.5

xmltable_clause syntax, 16.1

XMLTYPE, 2.2.1

XOR condition, 12.3

xqryarg syntax, 13.1

xqryargs_list

clause, 13.1

syntax, 13.1

xsd

dateTime, 2.4.3

xstream_clause syntax, 16.1

xtbl_col syntax, 16.1

xtbl_cols_list syntax, 16.1

Y

Y0 function, 7.1

Y1 function, 7.1

YN function, 7.1