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