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

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

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