Skip Headers
Oracle® Fusion Middleware CQL Language Reference for Oracle Complex Event Processing
11g Release 1 (11.1.1.6.3)

Part Number E12048-10
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

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
()
grouping pattern operator, 19.3.2
*
arithmetic operator multiply, 4.1.2
maximal pattern quantifier (0 or more times), 19.3.1
used with count function, 5.1, 5.1, 9.1.1, 9.1.1, 19.1.3.5, 19.1.3.5
used with select clause, 20.1
*?
minimal pattern quantifier (0 or more times), 19.3.1
+
arithmetic operator addition, 4.1.2
arithmetic operator positive, 4.1.2
maximal pattern quantifier (1 or more times), 19.3.1
relation insertion, 1.1.1.3
+?
minimal pattern quantifier (1 or more times), 19.3.1
:n
parameterized query placeholder, 18.2.11
?
maximal pattern quantifier (0 or 1 time), 19.3.1
??
minimal pattern quantifier (0 or 1 time), 19.3.1
|
alternation pattern operator, 19.3.2
||
concatenation operator, 4.1.2, 4.1.2

A

abs function, 12.1
abs1 function, 12.1
abs2 function, 12.1
abs3 function, 12.1
acos function, 12.1
aggr_distinct_expr syntax, 5.1
aggr_expr syntax, 5.1
aggregates
correlation variable restrictions, 19.1.3.2, 19.1.3.3, 19.1.3.4, 19.1.3.5
count in MATCH_RECOGNIZE clause, 19.1.3.5
expressions, 5.1, 5.1
final, 19.1.3.1
first in MATCH_RECOGNIZE clause, 19.1.3.6
functions, built-in, 9
functions, Colt built-in, 11
last in MATCH_RECOGNIZE clause, 19.1.3.6
prev in MATCH_RECOGNIZE clause, 19.1.4
referencing in MATCH_RECOGNIZE clause, 19.1.3
running, 19.1.3.1
XML aggregate expressions, 5.1
AggregationFunctionFactory, 13.2.2
aliases
about, 2.7
ALIASES element, 2.7.2
AS operator, 2.7.1
columns, 2.7.1.1
stream elements, 2.7.1.1
type aliases, 2.7.2.1
window operators, 2.7.1.2
ALL MATCHES clause
about, 19.7
partial overlapping patterns, 19.7
total overlapping patterns, 19.7
ALL operator, 6.2
alternation operator, 4.1.2
AND condition, 6.3, 6.3
ANY operator, 6.2
ANYINTERACT geometric relation operator, 16.2.7
API
AggregationFunctionFactory, 13.2.2
application context
data cartridges, 14.1.2
Oracle JDBC data cartridge, 17.1.4
Oracle Spatial, 16.1.4
application time, 1.1.13
application timestamped, 1.1.13
APPLICATION_NO_AUTO_IMPORT_CLASS_SPACE, 15.1.2.2
arguments of operators, 4
arith_expr syntax, 5.1
arith_expr_list syntax, 5.1
array_type
clause, 7.1
AS
alias operator, 2.7.1, 2.7.1.2
correlation_name_definition syntax, 19.4
measure_column syntax, 19.2
asc_desc syntax, 20.1
asin function, 12.1
atan function, 12.1
atan2 function, 12.1
attr
clause, 7.1
syntax, 7.1
attrspec
clause, 7.1
syntax, 7.1
autoCorrelation function, 11.1.2
avg function, 9.1.1

B

base relation, 1.1.1.2
base stream, 1.1.1.2
beta function, 10.1
beta1 function, 10.1
betaComplemented function, 10.1
BETWEEN conditions, 6.5
between_condition syntax, 6.5
BIGINT datatype, 2.1.1
binary
clause, 20.1
syntax, 20.1
binary operators, 4.1.1
bindings element, 18.2.11.2
binomial function, 10.1
binomial1 function, 10.1
binomial2 function, 10.1
binomialComplemented function, 10.1
bitMaskWithBitsSetFromTo function, 10.1
BOOLEAN datatype, 2.1.1
bufferPolygon Geometry method, 16.2.7
built-in datatypes, 2.1.1
built-in functions
about, 1.1.11
aggregate
about, 9
distinct, 9.1
nested, 9.1
where, group by, and having clause, 9.1.1, 9.1.1
Colt, 1.1.11, 1.1.11, 10, 11
where, group by, and having clause, 11.1.2
java.lang.Math, 1.1.11, 12
single-row
about, 8
built-in windows
about, 1.1.3
queries, 18.2.3
builtin_aggr syntax, 9.1
builtin_aggr_incr syntax, 9.1
BYTE datatype, 2.1.1

C

cache, 1.1.10
Oracle CQL queries, 18.5
Oracle CQL user-defined functions, 13.1.3
cache queries, 18.2.8
case_expr syntax, 5.1
cbrt function, 12.1
CDATA, 1.2.1
ceil function, 10.1
ceil1 function, 12.1
CEP DDL
use, 1.2.1
channels
query selector, 1.1.1.1.4
stream, 1.1.1.1.1
CHAR datatype, 2.1.1
character sets and multibyte characters, 2.8.1
chiSquare function, 10.1
chiSquareComplemented function, 10.1
class_name
clause, 7.1, 7.1
classpath
Oracle CEP Service Engine, 13.1, 13.2.1, 13.2.2
single-row user-defined functions, 13.2.1, 13.2.2
user-defined functions, 13.1
Colt built-in functions, 1.1.11, 1.1.11, 10, 11
where, group by, and having clause, 11.1.2
column aliases, 2.7.1.1
comments
CQL, 1.2.1, 2.6
XML, 8.1
comparison conditions
about, 6.2
simple, 6.2
comparison rules
character values, 2.2.3
datatypes, 2.2
date value, 2.2.2
complex_type
clause, 7.1
compound conditions, 6.7
compound_conditions syntax, 6.7
concat function, 8.1
concatenation operator, 4.1.2, 8.1
condition syntax, 6.2
conditions
about, 6
BETWEEN, 6.5
comparison
about, 6.2
simple, 6.2
compound, 6.7
compound_conditions syntax, 6.7
in, 6.8
logical
about, 6.3
AND, 6.3
NOT, 6.3
OR, 6.3
XOR, 6.3
nulls, 2.5.2, 6.6
pattern-matching
LIKE, 6.4
lk function, 8.1
precedence, 6.1.1
range, 6.5
const_bigint
clause, 7.1
syntax, 7.1
const_int
clause, 7.1
syntax, 7.1
const_string
clause, 7.1
quotation marks, 2.3.1
syntax, 7.1
text literals, 2.3.1
const_value
clause, 7.1
syntax, 7.1
CONTAIN geometric relation operator, 16.2.7
content, 5.1
Continuous Query Language. See CQL
conversion, 2.2.4
correlation function, 11.1.2
correlation variables, 19.1
correlation_name syntax, 19.3.1
correlation_name_definition syntax, 19.4
cos function, 12.1
cosh function, 12.1
count function, 9.1.1
covariance function, 11.1.2
CQL, 1.2.1, 1.2.1, 1.2.1, 1.2.1, 1.2.1
aliases
about, 2.7
ALIASES element, 2.7.2
AS operator, 2.7.1
type aliases, 2.7.2.1
comments, 1.2.1, 2.6
conditions, 6
.cqlx files, 1.2.1
datatype comparison rules, 2.2
datatypes, 2.1
expressions, 5
format models, 2.4
joins, 18
lexical conventions, 1.2.1
literals, 2.3
MATCH_RECOGNIZE, 19
naming rules, 2.8.1
nulls
about, 2.5
in comparison conditions, 2.5.2
in functions, 2.5.1
operators, 4
Oracle tools support of, 1.4
pattern recognition
about, 1.1.7, 19
pseudocolumns
about, 3
attr clause, 7.1
ELEMENT_TIME, 3.2
queries, 18
syntax, 1.2.3
views, 18
CQL data cartridge statements
array_type clause, 7.1
class_name clause, 7.1, 7.1
complex_type clause, 7.1
data_cartridge_name clause, 5.1
fieldname clause, 7.1, 7.1
link clause, 5.1
l-value clause, 7.1
methodname clause, 7.1
package_name clause, 7.1, 7.1
param_list clause, 7.1
qualified_type_name clause, 7.1
CQL statements
about, 1.2
array_type clause, 7.1
attr clause, 7.1
attrspec clause, 7.1
binary clause, 20.1
class_name clause, 7.1, 7.1
const_bigint clause, 7.1
const_int clause, 7.1
const_string clause, 7.1
const_value clause, 7.1
data_cartridge_name clause, 5.1
fieldname clause, 7.1, 7.1
identifier clause, 7.1
IN and NOT IN, 20.1
INTERSECT, 20.1
lexical conventions, 1.2.1
link clause, 5.1
l-value clause, 7.1
methodname clause, 7.1
MINUS, 20.1
non_mt_arg_list clause, 7.1
non_mt_attr_list clause, 7.1
non_mt_attrname_list clause, 7.1
non_mt_attrspec_list clause, 7.1
non_mt_cond_list clause, 7.1
package_name clause, 7.1, 7.1
param_list clause, 7.1
qualified_type_name clause, 7.1
query, 20.1
query_ref clause, 7.1
relation_variable, 20.1
set, 20.1
syntax conventions, 1.2.3
time_spec clause, 7.1
UNION and UNION ALL, 20.1
view, 20.1
xml_attr_list clause, 7.1
xml_attribute_list clause, 7.1
xqryargs_list clause, 7.1
.cqlx
case, 1.2.1
CDATA, 1.2.1
CEP DDL use, 1.2.1
comments, 1.2.1
lexical conventions, 1.2.1
rules, 1.2.1
statement terminator, 1.2.1
whitespace, 1.2.1
createElemInfo Geometry method, 16.2.7, 16.2.7
createGeometry Geometry method, 16.2.7
createLinearPolygon Geometry method, 16.2.7
createPoint Geometry method, 16.2.7
createRectangle Geometry method, 16.2.7

D

data cartridges
about, 1.1.12, 14.1
application context, 14.1.2
complex_type
constructor invocation, 7.1
field access, 7.1
instantiation, 7.1
method access, 7.1
data cartridge name
java, 15.1.1
jdbc, 17.1.1
spatial, 16.1.1
datatypes, and, 2.1.2
Oracle CQL queries, 18.7
Oracle JDBC data cartridge
application context, 17.1.4
Oracle Spatial
application context, 16.1.4
TABLE query, 18.2.7, 20.1
types
Java, 15.1
Oracle JDBC, 17.1
Oracle Spatial, 16.1
view schema, 20.1
data destinations
about, 1.1.8, 1.1.8.2
data sources
cache, 1.1.10
function table, 1.1.9.3
relational database table, 1.1.9.1
table, 1.1.9
XML table, 1.1.9.2
data_cartridge_name
clause, 5.1
datatype syntax, 2.1
datatypes
about, 2.1
aliases, 2.7.2.1
BIGINT, 2.1.1
BOOLEAN, 2.1.1
built-in, 2.1.1
BYTE, 2.1.1
CHAR, 2.1.1
comparison rules, 2.2.1
about, 2.2
character values, 2.2.3
conversion
about, 2.2.4
explicit, 2.2.4.2
implicit, 2.2.4.1
JDBC, 2.2.4.3
SQL, 2.2.4.3
user-defined functions, 2.2.4.4, 2.2.4.5, 13.1.2
data cartridges, 2.1.2
date value comparison rules, 2.2.2
DOUBLE, 2.1.1
enum, 2.1.3
evaluating with functions, 2.1.3
FLOAT, 2.1.1
format models
about, 2.4
datetime, 2.4.2, 8.1
number, 2.4.1
INTEGER, 2.1.1
INTERVAL, 2.1.1
literals
about, 2.3
float, 2.3.2.2
integer, 2.3.2.1
interval, 2.3.4
interval day to second, 2.3.4.1
text, 2.3.1
timestamp, 2.3.3
mapping in user-defined functions, 13.1.2
OBJECT, 2.1.1
opaque, 2.1.1
Oracle JDBC data cartridge, 17.1.2
Oracle Spatial, 16.1.2.1
other, 2.1.2, 2.1.3
TIMESTAMP, 2.1.1
type aliases, 2.7.2.1
unsupported, 2.1.2, 2.1.3
user-defined functions, 13.1.2
XMLTYPE, 2.1.1
datetime literals
about, 2.3.3
xsd
dateTime, 2.3.3
day, 7.1
days, 7.1
DDL
query, 20.1
view, 20.1
decimal characters, 2.3.2.2
decode
in arithmetic expressions, 5.1
nulls, 2.5.2
decode syntax, 5.1
DEFINE clause
about, 19.4
correlation names, 19.4.2, 19.4.3
derived stream, 1.1.1.2, 1.1.1.2
distance Geometry method, 16.2.7
distinct
aggregate expressions, 5.1
built-in aggregate functions, 9.1
function expressions, 5.1
relations, 1.1.2
select_clause, 20.1
document, 5.1
DOUBLE datatype, 2.1.1
double quotes, 2.3.1
Dstream relation-to-stream operator, 4.1.2
DURATION clause, 19.9
DURATION MULTIPLES OF clause, 19.9
duration_clause syntax, 19.9

E

Eclipse, 1.4.2
enum datatypes, 2.1.3
equality test, 6.2
errorFunction function, 10.1
errorFunctionComplemented function, 10.1
event sinks
about, 1.1.8, 1.1.8.2
event sources
about, 1.1.8, 1.1.8.1
cache, 1.1.10
function table, 1.1.9.3
pull, 1.1.8.1, 18.2.8, 18.6
push, 1.1.8.1
relational database table, 1.1.9.1
table, 1.1.9
XML table, 1.1.9.2
exp function, 12.1
expm1 function, 12.1
expressions
about, 5
aggr_distinct_expr, 5.1
aggr_expr, 5.1
aggregate, 5.1, 5.1
aggregate distinct, 5.1
arith_expr, 5.1
arith_expr_list, 5.1
arithmetic, 5.1, 5.1
case, 5.1
case_expr, 5.1
decode, 5.1, 5.1
func_expr, 5.1
function, 5.1, 5.1, 5.1, 5.1, 5.1
object, 5.1
object_expr, 5.1
order, 5.1
order_expr, 5.1
xml_agg_expr, 5.1
xml_parse_expr, 5.1
xmlcolattval_expr, 5.1
xmlelement_expr, 5.1
xmlforest_expr, 5.1
extended_builtin_aggr syntax, 9.1

F

factorial function, 10.1
fieldname
clause, 7.1, 7.1
FILTER geometric filter operator, 16.2.7
first function, 9.1.1
fixed duration non-event detection, 19.9.1
fixed_length_datatype syntax, 2.1
FLOAT datatype, 2.1.1
floor function, 10.1
floor1 function, 12.1
format models
about, 2.4
datetime, 2.4.2, 8.1
number, 2.4.1
from_clause syntax, 18.2.1.3, 18.4.2, 20.1
func_expr syntax, 5.1
func_name syntax, 5.1
functions
abs, 12.1
abs1, 12.1
abs2, 12.1
abs3, 12.1
acos, 12.1
asin, 12.1
atan, 12.1
atan2, 12.1
autoCorrelation, 11.1.2
avg, 9.1.1
beta, 10.1
beta1, 10.1
betaComplemented, 10.1
binomial, 10.1
binomial1, 10.1
binomial2, 10.1
binomialComplemented, 10.1
bitMaskWithBitsSetFromTo, 10.1
cbrt, 12.1
ceil, 10.1
ceil1, 12.1
chiSquare, 10.1
chiSquareComplemented, 10.1
concat, 8.1
correlation, 11.1.2
cos, 12.1
cosh, 12.1
count, 9.1.1
covariance, 11.1.2
errorFunction, 10.1
errorFunctionComplemented, 10.1
exp, 12.1
expm1, 12.1
factorial, 10.1
first, 9.1.1
floor, 10.1
floor1, 12.1
gamma, 10.1
gamma1, 10.1
gammaComplemented, 10.1
geometricMean, 11.1.2
geometricMean1, 11.1.2
getseedatrowcolumn, 10.1
harmonicMean, 11.1.2
hash, 10.1
hash1, 10.1
hash2, 10.1
hash3, 10.1
hextoraw, 8.1
hypot, 12.1
i0, 10.1
i0e, 10.1
i1, 10.1
i1e, 10.1
IEEERemainder, 12.1
incompleteBeta, 10.1
incompleteGamma, 10.1
incompleteGammaComplement, 10.1
j0, 10.1
j1, 10.1
jn, 10.1
k0, 10.1
k0e, 10.1
k1, 10.1
k1e, 10.1
kn, 10.1
kurtosis, 11.1.2
lag1, 11.1.2
last, 9.1.1
leastSignificantBit, 10.1
length, 8.1
lk, 8.1
log, 10.1
log1, 12.1
log10, 10.1
log101, 12.1
log1p, 12.1
log2, 10.1
logFactorial, 10.1
logGamma, 10.1
longFactorial, 10.1
max, 9.1.1
mean, 11.1.2
meanDeviation, 11.1.2
median, 11.1.2
min, 9.1.1
moment, 11.1.2
mostSignificantBit, 10.1
negativeBinomial, 10.1
negativeBinomialComplemented, 10.1
normal, 10.1
normal1, 10.1
normalInverse, 10.1
nvl, 8.1
ordsgenerator, 16.2.7
poisson, 10.1
poissonComplemented, 10.1
pooledMean, 11.1.2
pooledVariance, 11.1.2
pow, 12.1
prev, 8.1
product, 11.1.2
quantile, 11.1.2
quantileInverse, 11.1.2
rankInterpolated, 11.1.2
rawtohex, 8.1
rint, 12.1
rms, 11.1.2
round, 12.1
round1, 12.1
sampleKurtosis, 11.1.2
sampleKurtosisStandardError, 11.1.2
sampleSkew, 11.1.2
sampleSkewStandardError, 11.1.2
sampleVariance, 11.1.2
signum, 12.1
signum1, 12.1
sin, 12.1
sinh, 12.1
skew, 11.1.2
sqrt, 12.1
standardDeviation, 11.1.2
standardError, 11.1.2
stirlingCorrection, 10.1
studentT, 10.1
studentTInverse, 10.1
sum, 9.1.1
sumOfInversions, 11.1.2
sumOfLogarithms, 11.1.2
sumOfPowerDeviations, 11.1.2
sumOfPowers, 11.1.2
sumOfSquaredDeviations, 11.1.2
sumOfSquares, 11.1.2
systemtimestamp, 8.1
tables, 1.1.9.3
tan, 12.1
tanh, 12.1
to_bigint, 8.1
to_boolean, 8.1
to_char, 8.1
to_double, 8.1
to_float, 8.1
to_timestamp, 8.1
todegrees, 12.1
toradians, 12.1
trimmedMean, 11.1.2
ulp, 12.1
ulp1, 12.1
variance, 11.1.2
weightedMean, 11.1.2
winsorizedMean, 11.1.2
xmlagg, 9.1.1
xmlcomment, 8.1
xmlconcat, 8.1
xmlexists, 8.1
xmlquery, 8.1
y0, 10.1
y1, 10.1
yn, 10.1
functions about
AggregationFunctionFactory, 13.2.2
categories, 1.1.11
datatype mapping, 13.1.2
distinct and aggregate built-in functions, 9.1
java.lang.Math, 1.1.11
naming rules, 1.1.11, 2.8.1, 13.1.1
nested aggregates, 9.1
nulls, 2.5.1
overloading, 1.1.11, 2.8.1, 13.1.1
overriding, 1.1.11, 2.8.1, 13.1.1
single-row built-in, 1.1.11
user-defined, 1.1.11

G

gamma function, 10.1
gamma1 function, 10.1
gammacomplemented function, 10.1
geometricMean function, 11.1.2
geometricMean1 function, 11.1.2
Geometry class, 16.1.3
get2dMbr Geometry method, 16.2.7
getseedatrowcolumn function, 10.1
greater than or equal to tests, 6.2
greater than tests, 6.2
group by
ELEMENT_TIME, 3.2.2.2
GROUP BY clause, 20.1
ORDER BY clause, 19.6
PARTITION BY clause, 19.5
partitioned window, 4.1.2, 4.1.2, 4.1.2
group match, 19.1.2

H

harmonicMean function, 11.1.2
hash function, 10.1
hash1 function, 10.1
hash2 function, 10.1
hash3 function, 10.1
HAVING clause, 20.1
heartbeat
system timestamped relations, 1.1.13
system timestamped streams, 1.1.13
hextoraw function, 8.1
hour, 7.1
hours, 7.1
hypot function, 12.1

I

i0 function, 10.1
i0e function, 10.1
i1 function, 10.1
i1e function, 10.1
identifier
clause, 7.1
syntax, 7.1
IEEERemainder function, 12.1
IN clause, 20.1
in conditions, 6.8
in_condition_membership syntax, 6.8.2
in_condition_set syntax, 20.1
INCLUDE TIMER EVENTS clause, 19.10
incompleteBeta function, 10.1
incompleteGamma function, 10.1
incompleteGammaComplement function, 10.1
incremental computation
about, 13.1.1.2
implementing, 13.2.2
run-time behavior, 13.2.2
inequality test, 6.2
inner joins, 18.4.1
INSIDE geometric relation operator, 16.2.7
INTEGER datatype, 2.1.1
integer syntax, 2.3.2.1
integers
in CQL syntax, 2.3.2.1
precision of, 2.3.2.1
INTERSECT clause, 20.1
INTERVAL datatype, 2.1.1
interval_value syntax, 2.3.4.1, 7.1
IS NOT NULL condition, 6.6
IS NULL condition, 6.6
is-total-order, 1.1.13
Istream relation-to-stream operator, 4.1.2

J

j0 function, 10.1
j1 function, 10.1
Java data cartridge
about, 15.1
class loading
about, 15.1.2
application class space policy, 15.1.2.1
example, 15.1.2.4
method resolution, 15.1.3
no automatic import class space policy, 15.1.2.2
server class space policy, 15.1.2.3
data cartridge name, 15.1.1
datatype mapping, 15.1.4
default package name, 15.1.1
java.lang package, 15.1.1
limitations, 15.1.5
method resolution, 15.1.3
Oracle CQL query support, 15.1.5
queries
limitations, 15.1.5
using exported Java classes, 15.2.2
using the Java API, 15.2.1
unqualified types, 15.1.1
java.lang.Math built-in functions, 12
jc:jdbc-ctx, 17.1.4.2
jdbc:jdbc-context, 17.1.4.1
jn function, 10.1
joins
about, 18, 18.4
inner, 18.4.1
left outer, 18.4.2, 18.4.2.1
outer, 18.4.2, 18.4.2.1, 18.4.2.2, 18.4.2.3
outer join look-back, 18.4.2.3
right outer, 18.4.2, 18.4.2.2
simple, 18.4.1
views, 18.3.1

K

k0 function, 10.1
k0e function, 10.1
k1 function, 10.1
k1e function, 10.1
keywords in object names, 2.8.1, 7.1, 7.1
kn function, 10.1
kurtosis function, 11.1.2

L

lag1 function, 11.1.2
last function, 9.1.1
leastSignificantBit function, 10.1
left outer joins, 18.4.2, 18.4.2.1
length function, 8.1
less than tests, 6.2
lexical conventions
about, 1.2.1
case, 1.2.1, 1.2.1
CDATA, 1.2.1, 1.2.1
CEP DDL use, 1.2.1, 1.2.1
comments, 1.2.1
.cqlx, 1.2.1
query, 1.2.1
statement terminator, 1.2.1, 1.2.1
view, 1.2.1
whitespace, 1.2.1, 1.2.1
LIKE condition, 6.4, 8.1
like_condition syntax, 6.4
link
clause, 5.1
literals, 2.3
lk function, 8.1
locale
decimal characters, 2.3.2.2
nonquoted identifiers, 2.8.1
ORDER BY, 18.2.9
RAWTOHEX, 8.1
text literals, 2.3.1
log function, 10.1
log1 function, 12.1
log10 function, 10.1
log101 function, 12.1
log1p function, 12.1
log2 function, 10.1
logFactorial function, 10.1
logGamma function, 10.1
logical conditions, 6.3
AND, 6.3
NOT, 6.3
OR, 6.3
XOR, 6.3
longFactorial function, 10.1
l-value
clause, 7.1

M

MATCH_RECOGNIZE clause
about, 19
aggregates
about, 19.1.3
correlation variable restrictions, 19.1.3.2, 19.1.3.3, 19.1.3.4, 19.1.3.5
count, 19.1.3.5
count(*), 19.1.3.5
count(identifier.*), 19.1.3.5
count(identifier.attr), 19.1.3.5
final, 19.1.3.1
first, 19.1.3.6
last, 19.1.3.6
prev, 19.1.4
running, 19.1.3.1
ALL MATCHES clause
about, 19.7
partial overlapping patterns, 19.7
total overlapping patterns, 19.7
correlation variables, 19.1
DEFINE clause, 19.4
DURATION clause, 19.9
DURATION MULTIPLES OF clause, 19.9
examples
non-event detection, fixed duration, 19.12.5
pattern detection, 19.12.1
pattern detection with aggregates, 19.12.3
pattern detection with partition by, 19.12.2
WITHIN clause, 19.12.4
group match, 19.1.2
INCLUDE TIMER EVENTS clause, 19.10
MEASURES clause, 19.2
ORDER BY clause, 19.6
PARTITION BY clause, 19.5
PATTERN clause
about, 19.3
alternation operator, 19.3.2
default, 19.3.1
group matches, 19.1.2
grouping operator, 19.3.2
quantifiers, 19.3.1
regular expressions, 19.3.1
singleton matches, 19.1.2
queries, 18.2.4
singleton match, 19.1.2
sub-clauses
optional, 19.1
principle, 19.1
SUBSET clause, 19.11
WHERE clause, 19.1.1
WITHIN clause, 19.8
WITHIN INCLUSIVE clause, 19.8
max function, 9.1.1
MBR
geometric index, 16.1.2.4
get2dMbr method, 16.2.7
getMBR method, 16.1.2.7.2
mean function, 11.1.2
meanDeviation function, 11.1.2
measure_column syntax, 19.2
MEASURES clause, 19.2
median function, 11.1.2
methodname
clause, 7.1
millisecond, 7.1
milliseconds, 7.1
min function, 9.1.1
Minimum Bounding Rectangle. See MBR
MINUS clause, 20.1
minute, 7.1
minutes, 7.1
moment function, 11.1.2
mostSignificantBit function, 10.1
multibyte characters, 2.8.1

N

naming rules
about, 2.8.1
NaN, 9.1.1
nanosecond, 7.1
nanoseconds, 7.1
negativeBinomial function, 10.1
negativeBinomialComplemented function, 10.1
NN geometric relation operator, 16.2.7
non_mt_arg_list
clause, 7.1
syntax, 7.1
non_mt_arg_list_set syntax, 6.8.2
non_mt_attr_list
clause, 7.1
syntax, 7.1
non_mt_attrname_list
clause, 7.1
syntax, 7.1
non_mt_attrspec_list
clause, 7.1
syntax, 7.1
non_mt_cond_list
clause, 7.1
syntax, 7.1
non_mt_corr_list syntax, 19.11
non_mt_corrname_definition_list syntax, 19.4
non_mt_measure_list syntax, 19.2
non_mt_projterm_list syntax, 20.1
non_mt_relation_list syntax, 20.1
non_mt_subset_definition_list syntax, 19.11
non-event detection
about, 19.12.5
fixed duration, 19.9.1, 19.12.5
recurring, 19.9.2
non-events, 19.12.5
normal function, 10.1
normal1 function, 10.1
normalInverse function, 10.1
NOT condition, 6.3, 6.3
NOT IN clause, 20.1
null_conditions syntax, 6.6
null_spec syntax, 20.1
nulls
about, 2.5
conditions, 6.6
decode, 2.5.2
in conditions, 2.5.3, 2.5.3
in functions, 2.5.1
IS NOT NULL condition, 6.6
IS NULL condition, 6.6
nvl function, 8.1
value conversion, 8.1
with comparison conditions, 2.5.2
number precision, 2.3.2.2
number syntax, 2.3.2.2
numeric literals
NaN, 9.1.1
numeric values
about, 2.2.1
comparison rules, 2.2.1
nvl function, 8.1

O

OBJECT datatype, 2.1.1
object names and keywords, 2.8.1, 7.1, 7.1
object_expr syntax, 5.1
OCEP_JAVA_CARTRIDGE_CLASS_SPACE, 15.1.2.2, 15.1.2.3
ON clause, 18.4.2
opaque data type, 2.1.1
operands, 4
operations
relation-to-stream, 1.1.4
stream-to-stream, 1.1.5
operators, 4
arithmetic, 4.1.2
binary, 4.1.1
concatenation, 4.1.2, 4.1.2, 8.1, 8.1
precedence, 4.1.2
relation-to-stream
Dstream, 4.1.2
Istream, 4.1.2
Rstream, 4.1.2
stream-to-relation
about, 1.1.3
default, 1.1.3.3
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, 20.1
opt_having_clause syntax, 20.1
opt_where_clause syntax, 20.1
OR condition, 6.3, 6.3
Oracle JDBC data cartridge
about, 17.1
application context
about, 17.1.4
jc:jdbc-ctx, 17.1.4.2
jdbc:jdbc-context, 17.1.4.1
data cartridge name, 17.1.1
datatype mapping
about, 17.1.3
param element, 17.2.1.2.1
return-component-type element, 17.2.1.2.2
sql element, 17.2.1.2.3
Oracle CQL queries, 17.2.2
scope, 17.1.2
SQL statements, 17.2.1
Oracle Spatial
about, 16.1
application context, 16.1.4
coordinate systems, 16.1.2.3
data cartridge name, 16.1.1
datatype mapping, 16.1.3
functions
ordsgenerator, 16.2.7
Geometry class, 16.1.3
Geometry methods
about, 16.1.2.7
bufferPolygon, 16.2.7
createElemInfo, 16.2.7, 16.2.7
createGeometry, 16.2.7
createLinearPolygon, 16.2.7
createPoint, 16.2.7
createRectangle, 16.2.7
distance, 16.2.7
get2dMbr, 16.2.7
to_Geometry, 16.2.7
to_JGeometry, 16.2.7
indexing, 16.1.2.4
MBR, 16.1.2.4, 16.1.2.7.2, 16.2.7
operators
ANYINTERACT, 16.2.7
CONTAIN, 16.2.7
FILTER, 16.2.7
filter, 16.1.2.6
INSIDE, 16.2.7
NN, 16.1.2.6, 16.2.7
relation, 16.1.2.5
WITHINDISTANCE, 16.2.7
ordinate systems, 16.1.2.3
scope
about, 16.1.2
coordinate systems, 16.1.2.3
datatypes, 16.1.2.1
element info array, 16.1.2.2
filter operators, 16.1.2.6
geometrix index, 16.1.2.4
Geometry methods, 16.1.2.7
MBR, 16.1.2.4
ordinate systems, 16.1.2.3
relation operators, 16.1.2.5
Oracle tools
about, 1.4
support of CQL, 1.4
ORDER BY clause, 19.6
about, 20.1, 20.1
data cartridge
field access, 7.1
of SELECT, 18.2.9
order by top, 20.1
rows, 20.1
ORDER BY ROWS clause, 20.1
order_by_clause syntax, 18.2.9, 20.1
order_by_list syntax, 20.1
order_by_top_clause syntax, 20.1
order_expr syntax, 5.1
orderterm syntax, 20.1
ordsgenerator function, 16.2.7
outer join look-back, 18.4.2.3
outer joins, 18.4.2, 18.4.2.1, 18.4.2.2, 18.4.2.3
ON clause, 18.4.2
overlapping patterns
partial, 19.7
total, 19.7
overloading functions, 1.1.11, 2.8.1, 13.1.1
overriding
functions, 1.1.11, 2.8.1, 13.1.1

P

package_name
clause, 7.1, 7.1
param_list
clause, 7.1
parameterized queries
about, 18.2.11
bindings element, 18.2.11.2
lexical conventions, 18.2.11.4
Oracle CQL statements, 18.2.11.1
parameter values, 18.2.11.4
runtime, 18.2.11.5
views, 18.2.11
partial overlapping patterns, 19.7
partition by
rows, 4.1.2
rows and range, 4.1.2
rows, range, and slide, 4.1.2
window specification, 1.1.3.2
PARTITION BY clause, 19.5
PATTERN clause
about, 19.3
alternation operator, 19.3.2
default, 19.3.1
group matches, 19.1.2
grouping operator, 19.3.2
permutation, 19.3.2
quantifiers, 19.3.1
regular expressions, 19.3.1
singleton matches, 19.1.2
pattern quantifier
(), 19.3.2
*, 19.3.1
*?, 19.3.1
+, 19.3.1
+?, 19.3.1
?, 19.3.1
??, 19.3.1
|, 19.3.2
0 or 1 times (maximal), 19.3.1
0 or 1 times (minimal), 19.3.1
0 or more times (maximal), 19.3.1
0 or more times (minimal), 19.3.1
1 or more times (maximal), 19.3.1
1 or more times (minimal), 19.3.1
alternation, 19.3.2
exactly 1 time, 19.3.1
grouping, 19.3.2
None, 19.3.1
pattern recognition. See MATCH_RECOGNIZE clause
pattern_clause syntax, 19.3
pattern_def_dur_clause syntax, 19.1
pattern_definition_clause syntax, 19.4
pattern_inc_timer_evs_clause syntax, 19.10
pattern_measures_clause syntax, 19.2
pattern_partition_clause syntax, 19.5, 19.6
pattern_quantifier syntax, 19.3.1
pattern_recognition_clause syntax, 19.1
pattern_skip_match_clause syntax, 19.7
pattern-matching conditions
LIKE, 6.4
lk function, 8.1
poisson function, 10.1
poissonComplemented function, 10.1
pooledMean function, 11.1.2
pooledVariance function, 11.1.2
pow function, 12.1
precedence
operators, 4.1.2
precision and number of digits of, 2.3.2.2
prev function, 8.1
product function, 11.1.2
projterm syntax, 20.1
pseudo_column syntax, 7.1
pseudocoloumns
about, 3
attr clause, 7.1
ELEMENT_TIME
about, 3.2
application-timestamped value, 3.2.1.2
bigint application-timestamped value, 3.2.1.2.1
int application-timestamped value, 3.2.1.2.1
system-timestamped value, 3.2.1.1
timestamp application-timestamped value, 3.2.1.2.2
with GROUP BY, 3.2.2.2
with PATTERN, 3.2.2.3
with SELECT, 3.2.2.1
pull event sources, 1.1.8.1, 18.2.8, 18.6
push event sources, 1.1.8.1

Q

qualified_type_name
clause, 7.1
quantile function, 11.1.2
quantileInverse function, 11.1.2
queries
about, 18, 18.2
built-in windows, 18.2.3
cache, 18.2.8, 18.5
data cartridges, 18.7
detecting differences, 18.2.10
DIFFERENCE USING, 18.2.10
MATCH_RECOGNIZE clause, 18.2.4
ORDER_BY, 18.2.9
parameterized, 18.2.11
simple, 18.2.2
sorting, 18.2.9
subqueries, 1.1.6, 18.1
TABLE, 18.2.7, 20.1
table
data cartridge, 18.2.7, 20.1
relational database, 18.2.5
relational database datatypes, 2.2.4.3
XML, 18.2.6
views, 18.3
XMLTABLE, 18.2.6
query
attributes
id, 20.1
statement, 20.1
query syntax, 18.2, 20.1
query_ref
clause, 7.1
syntax, 7.1
quotation marks
about, 2.3.1
locale, 2.8.1
text literals, 2.3.1
quoted_string_double_quotes syntax, 7.1
quoted_string_single_quotes syntax, 7.1

R

range
conditions, 6.5
window specification
about, 1.1.3.1
default, 1.1.3.1
rankInterpolated function, 11.1.2
rawtohex function, 8.1
recurring non-event detection, 19.9.2
regexp syntax, 19.3.1
regexp_grp_alt syntax, 19.3.2
relation_variable syntax, 18.2.1.3, 20.1
relational database tables, 1.1.9.1
relations
about, 1.1.1.2
base, 1.1.1.2
distinct, 1.1.2
heartbeat, 1.1.13
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.8.1, 2.8.1, 7.1
right outer joins, 18.4.2, 18.4.2.2
rint function, 12.1
rms function, 11.1.2
round function, 12.1
round1 function, 12.1
Rstream relation-to-stream operator, 4.1.2

S

sampleKurtosis function, 11.1.2
sampleKurtosisStandardError function, 11.1.2
sampleSkew function, 11.1.2
sampleSkewStandardError function, 11.1.2
sampleVariance function, 11.1.2
scheduler
time, 1.1.13
schema
relation, 1.1.1.2
stream, 1.1.1.1, 1.1.1.1.2
schema objects
naming
examples, 2.8.3
guidelines, 2.8.2
searched_case syntax, 5.1
searched_case_list syntax, 5.1
second, 7.1
seconds, 7.1
select_clause
distinct, 20.1
syntax, 18.2.1.2, 20.1
SERVER_CLASS_SPACE, 15.1.2.3
set statements
about, 20.1
IN and NOT IN, 20.1
INTERSECT, 20.1
MINUS, 20.1
UNION and UNION ALL, 20.1
sfw_block syntax, 18.2.1.1, 20.1
signum function, 12.1
signum1 function, 12.1
simple comparison conditions, 6.2
simple joins, 18.4.1
simple queries, 18.2.2
simple_case syntax, 5.1
simple_case_list syntax, 5.1
sin function, 12.1
single quotes, 2.3.1
singleton match, 19.1.2
sinh function, 12.1
skew function, 11.1.2
slide
window specification
about, 1.1.3.1
default, 1.1.3.1
SOME operator, 6.2
sorting query results, 18.2.9
SQL99, 1.3
SQLX
about, 5.1
content, 5.1
datatype conversion, 2.2.4.3
document, 5.1
expressions, 5.1
func_expr, 5.1
functions, 8.1
wellformed, 5.1
xml_agg_expr, 5.1
xml_parse_expr, 5.1
xmlagg function, 9.1.1
xmlcolattval_expr, 5.1
xmlcomment function, 8.1
xmlconcat function, 8.1
xmlelement_expr, 5.1
xmlexists function, 8.1
xmlforest_expr, 5.1
xmlquery function, 8.1
SQL/XML. See SQLX
sqrt function, 12.1
standardDeviation function, 11.1.2
standardError function, 11.1.2
standards, 1.3
statement terminator, 1.2.1
stirlingCorrection function, 10.1
streams
about, 1.1.1.1
base, 1.1.1.2
channel, 1.1.1.1.1
derived, 1.1.1.2, 1.1.1.2
heartbeat, 1.1.13
query selector, 1.1.1.1.4
relation, 1.1.1.2, 1.1.1.2
schema, 1.1.1.1, 1.1.1.1.2
tuple, 1.1.1.1
stream-to-relation operators
about, 1.1.3
default, 1.1.3.3
group by, 3.2.2.2, 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, 10.1
studentTInverse function, 10.1
subqueries, 1.1.6, 1.1.6, 18.1
SUBSET clause, 19.11
subset_clause
about, 19.11
syntax, 19.11
subset_definition syntax, 19.11
subset_name syntax, 19.11
sum function, 9.1.1
sumOfInversions function, 11.1.2
sumOfLogarithms function, 11.1.2
sumOfPowerDeviations function, 11.1.2
sumOfPowers function, 11.1.2
sumOfSquaredDeviations function, 11.1.2
sumOfSquares function, 11.1.2
synonyms. See aliases
Syntax, 10.1
system time, 1.1.13
system timestamped, 1.1.13
systemtimestamp function, 8.1

T

TABLE queries, 18.2.7, 20.1
table_clause syntax, 18.2.7, 20.1
tables, 1.1.9
queries
data cartridge, 18.2.7, 20.1
relational database, 18.2.5
relational database datatypes, 2.2.4.3
XML, 18.2.6
tan function, 12.1
tanh function, 12.1
terminator, 1.2.1
text literals
about, 2.3.1
quotation marks, 2.3.1
time
about, 1.1.13
application, 1.1.13
application timestamped, 1.1.13
heartbeat, 1.1.13
is-total-order, 1.1.13
scheduler, 1.1.13
system, 1.1.13
system timestamped, 1.1.13
time system timestamped, 1.1.13
time_spec
clause, 7.1
syntax, 7.1
time_unit
syntax, 7.1
TIMESTAMP
about, 2.3.3
xsd
dateTime, 2.3.3
TIMESTAMP datatype, 2.1.1
timestamps
application, 1.1.13
system, 1.1.13
to_bigint function, 8.1
to_boolean function, 8.1
to_char function, 8.1
to_double function, 8.1
to_float function, 8.1
to_Geometry Geometry method, 16.2.7
to_JGeometry Geometry method, 16.2.7
to_timestamp function, 8.1
todegrees function, 12.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, 12.1
total overlapping patterns, 19.7
trimmedMean function, 11.1.2
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, 12.1
ulp1 function, 12.1
unary operators, 4.1.1
UNION ALL clause, 20.1
UNION clause, 20.1
unreserved words, 7.1
unreserved_keyword syntax, 7.1
user-defined functions
about, 1.1.11, 13
aggregate, 13.1.1.2
cache, 13.1.3
classpath, 13.2.1, 13.2.2
datatype mapping, 13.1.2
implementing, 13.1, 13.2
aggregate, 13.2.2
AggrFunctionImpl, 13.2.2
SingleElementFunction, 13.2.1
single-row, 13.2.1
incremental computation
about, 13.1.1.2
implementing, 13.2.2
run-time behavior, 13.2.2
single-row, 13.1.1.1
types of, 13.1.1
using_clause syntax, 18.2.10, 20.1
usingexpr syntax, 20.1
usinglist syntax, 20.1
usingterm syntax, 20.1

V

variable_length_datatype syntax, 2.1
variance function, 11.1.2
view
attributes
id, 20.1
schema, 20.1
statement, 20.1
views
about, 18
joins, 18.3.1
queries, 18.3
schema, 18.3.2
visibility, 18.3

W

weightedMean function, 11.1.2
wellformed, 5.1
WHERE clause
built-in aggregate functions, 9.1.1
Colt aggregate functions, 11.1.2
group by and having clause, 9.1.1, 11.1.2
MATCH_RECOGNIZE clause, 19.1.1
window_type syntax, 1.1.3, 20.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.2, 4.1.2, 4.1.2, 4.1.2
range specification
about, 1.1.3.1
default, 1.1.3.1
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
about, 1.1.3.1
default, 1.1.3.1
Unbounded, 4.1.2
winsorizedMean function, 11.1.2
WITHIN clause, 19.8
WITHIN INCLUSIVE clause, 19.8
within_clause syntax, 19.8
WITHINDISTANCE geometric relation operator, 16.2.7

X

XML tables, 1.1.9.2
xml_agg_expr syntax, 5.1
xml_attr syntax, 7.1
xml_attr_list
clause, 7.1
syntax, 7.1
xml_attribute_list
clause, 7.1
syntax, 7.1
xml_namespace syntax, 20.1
xmlagg function, 9.1.1
xmlcolattval_expr syntax, 5.1, 5.1
xmlcomment function, 8.1
xmlconcat function, 8.1
xmlexists function, 8.1
xmlforest_expr syntax, 5.1, 5.1
xmlnamespace_clause syntax, 20.1
xmlnamespaces_list syntax, 20.1
xmlquery function, 8.1
XMLTABLE queries, 18.2.6
xmltable_clause syntax, 20.1
XMLTYPE datatype, 2.1.1
XOR condition, 6.3
xqryarg syntax, 7.1
xqryargs_list
clause, 7.1
syntax, 7.1
xsd
dateTime, 2.3.3
xstream_clause syntax, 20.1
xtbl_col syntax, 20.1
xtbl_cols_list syntax, 20.1

Y

y0 function, 10.1
y1 function, 10.1
yn function, 10.1