Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions
• Syntax Diagrams

1 Introduction to Oracle CQL

• 1.1 Fundamentals of Oracle CQL
  • 1.1.1 Streams and Relations
    • 1.1.1.1 Streams
    • 1.1.1.2 Relations
    • 1.1.1.3 Relations and Oracle CEP Tuple Kind Indicator
  • 1.1.2 Relation-to-Relation Operators
  • 1.1.3 Stream-to-Relation Operators (Windows)
  • 1.1.4 Relation-to-Stream Operators
  • 1.1.5 Stream-to-Stream Operators
  • 1.1.6 Queries, Views, and Joins
  • 1.1.7 Pattern Recognition
  • 1.1.8 Event Sources and Event Sinks
    • 1.1.8.1 Event Sources
    • 1.1.8.2 Event Sinks
  • 1.1.9 Functions
  • 1.1.10 Time
• 1.2 Oracle CQL Statements
  • 1.2.1 Oracle CQL Statement Lexical Conventions
  • 1.2.2 Oracle CQL Statement Documentation Conventions
• 1.3 Oracle CQL and SQL Standards
• 1.4 Oracle CEP Server and Tools Support
  • 1.4.1 Oracle CEP Server
  • 1.4.2 Oracle CEP Tools

2 Basic Elements of Oracle CQL

• 2.1 Introduction to Basic Elements of Oracle CQL
• 2.2 Datatypes
  • 2.2.1 Oracle CQL Built-in Datatypes
  • 2.2.2 Handling Other Datatypes Using a User-Defined Function
• 2.3 Datatype Comparison Rules
  • 2.3.1 Numeric Values
  • 2.3.2 Date Values
  • 2.3.3 Character Values
  • 2.3.4 Data Conversion
    • 2.3.4.1 Implicit Data Conversion
    • 2.3.4.2 Explicit Data Conversion
    • 2.3.4.3 User-Defined Function Data Conversion
• 2.4 Literals
  • 2.4.1 Text Literals
  • 2.4.2 Numeric Literals
    • 2.4.2.1 Integer Literals
    • 2.4.2.2 Floating-Point Literals
  • 2.4.3 Datetime Literals
  • 2.4.4 Interval Literals
    • 2.4.4.1 INTERVAL DAY TO SECOND
• 2.5 Format Models
  • 2.5.1 Number Format Models
  • 2.5.2 Datetime Format Models
• 2.6 Nulls
  • 2.6.1 Nulls in Oracle CQL Functions
  • 2.6.2 Nulls with Comparison Conditions
  • 2.6.3 Nulls in Conditions
• 2.7 Comments
• 2.8 Aliases
  • 2.8.1 Aliases in the relation_variable Clause
  • 2.8.2 Aliases in Window Operators
• 2.9 Schema Object Names and Qualifiers
  • 2.9.1 Schema Object Naming Rules
  • 2.9.2 Schema Object Naming Guidelines
  • 2.9.3 Schema Object Naming Examples

3 Pseudocolumns

• 3.1 Introduction to Pseudocolumns
• 3.2 ELEMENT_TIME Pseudocolumn

4 Operators

• 4.1 Introduction to Operators
  • 4.1.1 What You May Need to Know About Unary and Binary Operators
  • 4.1.2 What You May Need to Know About Operator Precedence
• Arithmetic Operators
• Concatenation Operator
• Range-Based Stream-to-Relation Window Operators
  • S[now]
  • S[range T]
  • S[range T1 slide T2]
  • S[range unbounded]
  • S[range C on E]
• Tuple-Based Stream-to-Relation Window Operators
  • S [rows N]
  • S [rows N1 slide N2]
• Partitioned Stream-to-Relation Window Operators
  • S [partition by A1,..., Ak rows N]
  • S [partition by A1,..., Ak rows N range T]
  • S [partition by A1,..., Ak rows N range T1 slide T2]
• IStream Relation-to-Stream Operator
• DStream Relation-to-Stream Operator
• RStream Relation-to-Stream Operator

5 Functions: Single-Row

• 5.1 Introduction to Oracle CQL Built-In Single-Row Functions
• CONCAT
• HEXTORAW
• LENGTH
• LK
• NVL
• PREV
• RAWTOHEX
• SYSTIMESTAMP
• TO_BIGINT
• TO_BOOLEAN
• TO_CHAR
• TO_DOUBLE
• TO_FLOAT
• TO_TIMESTAMP
• XMLCOMMENT
• XMLCONCAT
• XMLEXISTS
• XMLQUERY

6 Functions: Aggregate

• 6.1 Introduction to Oracle CQL Built-In Aggregate Functions
• AVG
• COUNT
• FIRST
• LAST
• MAX
• MIN
• SUM
• XMLAGG

7 Functions: Colt Single-Row

• 7.1 Introduction to Oracle CQLBuilt-In Single-Row Colt Functions
• BETA
• BETA1
• BETACOMPLEMENTED
• BINOMIAL
• BINOMIAL1
• BINOMIAL2
• BINOMIALCOMPLEMENTED
• BITMASKWITHBITSSETFROMTO
• CEIL
• CHISQUARE
• CHISQUARECOMPLEMENTED
• ERRORFUNCTION
• ERRORFUNCTIONCOMPLEMENTED
• FACTORIAL
• FLOOR
• GAMMA
• GAMMA1
• GAMMACOMPLEMENTED
• GETSEEDATROWCOLUMN
• HASH
• HASH1
• HASH2
• HASH3
• I0
• I0E
• I1
• I1E
• INCOMPLETEBETA
• INCOMPLETEGAMMA
• INCOMPLETEGAMMACOMPLEMENT
• J0
• J1
• JN
• K0
• K0E
• K1
• K1E
• KN
• LEASTSIGNIFICANTBIT
• LOG
• LOG10
• LOG2
• LOGFACTORIAL
• LOGGAMMA
• LONGFACTORIAL
• MOSTSIGNIFICANTBIT
• NEGATIVEBINOMIAL
• NEGATIVEBINOMIALCOMPLEMENTED
• NORMAL
• NORMAL1
• NORMALINVERSE
• POISSON
• POISSONCOMPLEMENTED
• STIRLINGCORRECTION
• STUDENTT
• STUDENTTINVERSE
• Y0
• Y1
• YN

8 Functions: Colt Aggregate

• 8.1 Introduction to Oracle CQL Built-In Aggregate Colt Functions
  • 8.1.1 Oracle CQL Colt Aggregate Function Signatures and Tuple Arguments
• AUTOCORRELATION
• CORRELATION
• COVARIANCE
• DURBINWATSON
• GEOMETRICMEAN
• GEOMETRICMEAN1
• HARMONICMEAN
• KURTOSIS
• LAG1
• MEAN
• MEANDEVIATION
• MEDIAN
• MOMENT
• POOLEDMEAN
• POOLEDVARIANCE
• PRODUCT
• QUANTILE
• QUANTILEINVERSE
• RANKINTERPOLATED
• RMS
• SAMPLEKURTOSIS
• SAMPLEKURTOSISSTANDARDERROR
• SAMPLESKEW
• SAMPLESKEWSTANDARDERROR
• SAMPLESTANDARDDEVIATION
• SAMPLEVARIANCE
• SKEW
• STANDARDDEVIATION
• STANDARDERROR
• SUMOFINVERSIONS
• SUMOFLOGARITHMS
• SUMOFPOWERDEVIATIONS
• SUMOFPOWERS
• SUMOFSQUAREDDEVIATIONS
• SUMOFSQUARES
• TRIMMEDMEAN
• VARIANCE
• WEIGHTEDMEAN
• WINSORIZEDMEAN

9 Functions: java.lang.Math

• 9.1 Introduction to Oracle CQL Built-In java.lang.Math Functions
• ABS
• ABS1
• ABS2
• ABS3
• ACOS
• ASIN
• ATAN
• ATAN2
• CBRT
• CEIL1
• COS
• COSH
• EXP
• EXPM1
• FLOOR1
• HYPOT
• IEEEREMAINDER
• LOG1
• LOG101
• LOG1P
• POW
• RINT
• ROUND
• ROUND1
• SIGNUM
• SIGNUM1
• SIN
• SINH
• SQRT
• TAN
• TANH
• TODEGREES
• TORADIANS
• ULP
• ULP1

10 Functions: User-Defined

• 10.1 Introduction to Oracle CQL User-Defined Functions
  • 10.1.1 Types of User-Defined Functions
  • 10.1.2 User-Defined Function Datatypes
  • 10.1.3 User-Defined Functions and the Oracle CEP Server Cache
• 10.2 Implementing a User-Defined Function
  • 10.2.1 How to Implement a User-Defined Single-Row Function
  • 10.2.2 How to Implement a User-Defined Aggregate Function

11 Expressions

• 11.1 Introduction to Expressions
• aggr_distinct_expr
• aggr_expr
• arith_expr
• arith_expr_list
• case_expr
• decode
• func_expr
• order_expr
• xml_agg_expr
• xmlcolattval_expr
• xmlelement_expr
• xmlforest_expr
• xml_parse_expr

12 Conditions

• 12.1 Introduction to Conditions
  • 12.1.1 Condition Precedence
• 12.2 Comparison Conditions
• 12.3 Logical Conditions
• 12.4 LIKE Condition
  • 12.4.1 Examples
• 12.5 Range Conditions
• 12.6 Null Conditions
• 12.7 Compound Conditions
• 12.8 IN Condition

13 Common Oracle CQL DDL Clauses

• 13.1 Introduction to Common Oracle CQL DDL Clauses
• attr
• attrspec
• const_bigint
• const_int
• const_string
• const_value
• identifier
• non_mt_arg_list
• non_mt_attr_list
• non_mt_attrname_list
• non_mt_attrspec_list
• non_mt_cond_list
• out_of_line_constraint
• query_ref
• time_spec
• xml_attribute_list
• xml_attr_list
• xqryargs_list

14 Oracle CQL Queries, Views, and Joins

• 14.1 Introduction to Oracle CQL Queries, Views, and Joins
• 14.2 Queries
  • 14.2.1 Query Building Blocks
    • 14.2.1.1 Select, From, Where Block
    • 14.2.1.2 Select Clause
    • 14.2.1.3 From Clause
    • 14.2.1.4 Where Clause
    • 14.2.1.5 Group By Clause
    • 14.2.1.6 Order By Clause
    • 14.2.1.7 Having Clause
    • 14.2.1.8 Binary Clause
    • 14.2.1.9 Xstream Clause
  • 14.2.2 Simple Query
  • 14.2.3 Built-In Window Query
  • 14.2.4 MATCH_RECOGNIZE Query
  • 14.2.5 XMLTable Query
  • 14.2.6 Sorting Query Results
• 14.3 Views
• 14.4 Joins
  • 14.4.1 Inner Joins
  • 14.4.2 Outer Joins
    • 14.4.2.1 Left Outer Join
    • 14.4.2.2 Right Outer Join
    • 14.4.2.3 Outer Join Restrictions
• 14.5 Oracle CQL Queries and the Oracle CEP Server Cache

15 Pattern Recognition With MATCH_RECOGNIZE

• 15.1 Understanding Pattern Recognition With MATCH_RECOGNIZE
• 15.2 ALL MATCHES Clause
• 15.3 DEFINE Clause
• 15.4 DURATION Clause
• 15.5 MEASURES Clause
• 15.6 PARTITION BY Clause
• 15.7 PATTERN Clause
• 15.8 SUBSET Clause
• 15.9 Examples

16 Oracle CQL Statements

• 16.1 Introduction to Oracle CQL Statements
• Query
• View

Index