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.8.3 Connecting Event Sources and 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
• geometricmean
• geometricmean1
• harmonicmean
• kurtosis
• lag1
• mean
• meandeviation
• median
• moment
• pooledmean
• pooledvariance
• product
• quantile
• quantileinverse
• rankinterpolated
• rms
• samplekurtosis
• samplekurtosisstandarderror
• sampleskew
• sampleskewstandarderror
• 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 Look-Back
• 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.4.1 Using the DURATION Clause for Fixed Duration Non-Event Detection
  • 15.4.2 Using the DURATION Clause for Recurring Non-Event Detection
• 15.5 MEASURES Clause
• 15.6 PARTITION BY Clause
• 15.7 PATTERN Clause
• 15.8 SUBSET Clause
• 15.9 Examples
  • 15.9.1 Pattern Detection
  • 15.9.2 Pattern Detection With Partition By
  • 15.9.3 Pattern Detection With Aggregates
  • 15.9.4 Fixed Duration Non-Event Detection

16 Oracle CQL Statements

• 16.1 Introduction to Oracle CQL Statements
• Query
• View

Index