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
*
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
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
as
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
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
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
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
VIEW identifier, 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

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
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 duration non-event detection, 15.4.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, 14.4.2, 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
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
geometricmean1, 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
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
pooledmean, 8.1.1
pooledvariance, 8.1.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
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
systemtimestamp, 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
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
geometricmean1 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
about, 14, 14.4
inner, 14.4.1
left outer, 14.4.2
left outer join, 14.4.2.1
outer, 14.4.2, 14.4.2.1, 14.4.2.2, 14.4.2.3
outer join look-back, 14.4.2.3
right outer, 14.4.2
right outer join, 14.4.2.2
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
left outer joins, 14.4.2, 14.4.2.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, fixed duration, 15.9.4
pattern detection, 15.9.1
pattern detection with aggregates, 15.9.3
pattern detection with partition by, 15.9.2
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
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
about, 15.9.4
fixed duration, 15.4.1, 15.9.4
recurring, 15.4.2
non-events, 15.9.4
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
ON clause, 14.4.2
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 join look-back, 14.4.2.3
outer joins, 14.4.2, 14.4.2.1, 14.4.2.2, 14.4.2.3
ON clause, 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
pooledmean function, 8.1.1
pooledvariance function, 8.1.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
recurring non-event detection, 15.4.2
regexp syntax, 15.7
REGISTER VIEW identifier, 16.1
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
right outer joins, 14.4.2, 14.4.2.2
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
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
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
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
xmlcomment function, 5.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
Syntax, 7.1
system time, 1.1.10
system timestamped, 1.1.10
systemtimestamp 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

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
views
about, 14
queries, 14.3
visibility, 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
xml_namespace syntax, 16.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
xmlnamespace_clause syntax, 16.1
xmlnamespaces_list syntax, 16.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