2/30
List of Examples
1-1 Typical Oracle CQL Statements
1-2 Stock Ticker Data Stream
1-3 Stream Schema Definition
1-4 filterFanoutProcessor Oracle CQL Query Using priceStream
1-5 Using selector to Control Which Query Results are Output
1-6 Oracle CEP Tuple Kind Indicator in Relation Output
1-7 Relation-to-Relation Operation
1-8 Query Without Stream-to-Relation Operator
1-9 Equivalent Query
1-10 Relation-to-Stream Operation
1-11 Stream-to-Stream Operation
1-12 Query and View id Attribute
1-13 Typical Oracle CQL Processor Configuration Source File
1-14 Oracle CQL: Without Whitespace Formatting
1-15 Oracle CQL: With Whitespace Formatting
2-1 Enum Datatype ProcessStatus
2-2 Event Using Enum Datatype ProcessStatus
2-3 User-Defined Function to Evaluate Enum Datatype
2-4 Registering the User-Defined Function in Application Assembly File
2-5 Using the User-Defined Function to Evaluate Enum Datatype in an Oracle CQL Query
2-6 Invalid Event XSD: xsd:dateTime is Not Supported
2-7 Valid Event XSD: Using xsd:string Instead of xsd:dateTime
2-8 XML Event Payload
2-9 Comparing Intervals
2-10 Using the AS Operator in the SELECT Statement
2-11 Using the AS Operator After a Window Operator
2-12 aliases Element in a Processor Component Configuration File
2-13 Adding an aliases Element to a Processor
2-14 Adding a type-alias Element to a Processor
2-15 Adding the source and target Elements
2-16 Accessing the Methods and Fields of an Aliased Type
3-1 ELEMENT_TIME Pseudocolumn in a Select Statement
3-2 Input Stream
3-3 Output Relation
3-4 Query With GROUP BY
3-5 View
3-6 Query
3-7 ELEMENT_TIME Pseudocolumn in a Pattern
4-1 Concatenation Operator (||)
4-2 S [now] Query
4-3 S [now] Stream Input
4-4 S [now] Relation Output at Time 5000000000 ns
4-5 S [range T] Query
4-6 S [range T] Stream Input
4-7 S [range T] Relation Output
4-8 S [range T1 slide T2] Query
4-9 S [range T1 slide T2] Stream Input
4-10 S [range T1 slide T2] Relation Output
4-11 S [range unbounded] Query
4-12 S [range unbounded] Stream Input
4-13 S [range unbounded] Relation Output at Time 5000 ms
4-14 S [range unbounded] Relation Output at Time 205000 ms
4-15 S [range C on E] Constant Value: Query
4-16 S [range C on E] Constant Value: Stream Input
4-17 S [range C on E] Constant Value: Relation Output
4-18 S [range C on E] INTERVAL Value: Query
4-19 S [range C on E] INTERVAL Value: Stream Input
4-20 S [range C on E] INTERVAL Value: Relation Output
4-21 S [rows N] Query
4-22 S [rows N] Stream Input
4-23 S [rows N] Relation Output at Time 1003 ms
4-24 S [rows N] Relation Output at Time 1007 ms
4-25 S [rows N] Relation Output at Time 2001 ms
4-26 S [rows N1 slide N2] Query
4-27 S [rows N1 slide N2] Stream Input
4-28 S [rows N1 slide N2] Relation Output
4-29 S[partition by A1, ..., Ak rows N] Query
4-30 S[partition by A1, ..., Ak rows N] Stream Input
4-31 S[partition by A1, ..., Ak rows N] Relation Output
4-32 S[partition by A1, ..., Ak rows N range T] Query
4-33 S[partition by A1, ..., Ak rows N range T] Stream Input
4-34 S[partition by A1, ..., Ak rows N range T] Relation Output
4-35 S[partition by A1, ..., Ak rows N range T1 slide T2] Query
4-36 S[partition by A1, ..., Ak rows N range T1 slide T2] Stream Input
4-37 S[partition by A1, ..., Ak rows N range T1 slide T2] Relation Output
4-38 IStream
4-39 DStream
4-40 RStream
5-1 aggr_distinct_expr for COUNT
5-2 aggr_expr for COUNT
5-3 arith_expr
5-4 arith_expr_list
5-5 CASE Expression: SELECT * Query
5-6 CASE Expression: SELECT * Stream Input
5-7 CASE Expression: SELECT * Relation Output
5-8 CASE Expression: SELECT Query
5-9 CASE Expression: SELECT Stream S0 Input
5-10 CASE Expression: SELECT Stream S1 Input
5-11 CASE Expression: SELECT Relation Output
5-12 Arithmetic Expression and DECODE Query
5-13 Arithmetic Expression and DECODE Relation Input
5-14 Arithmetic Expression and DECODE Relation Output
5-15 func_expr for PREV
5-16 func_expr for XMLQUERY
5-17 func_expr for SUM
5-18 Data Cartridge TABLE Query
5-19 Type Declaration Using an Oracle CQL Data Cartridge Link
5-20 Field Access Using an Oracle CQL Data Cartridge Link
5-21 Type Declaration Using an Oracle CQL Data Cartridge Link
5-22 Type Declaration Using an Oracle CQL Data Cartridge Link
5-23 order_expr
5-24 xml_agg_expr Query
5-25 xml_agg_expr Relation Input
5-26 xml_agg_expr Relation Output
5-27 xmlcolattval_expr Query
5-28 xmlcolattval_expr Relation Input
5-29 xmlcolattval_expr Relation Output
5-30 xmlelement_expr Query
5-31 xmlelement_expr Relation Input
5-32 xmlelement_expr Relation Output
5-33 xmlforest_expr Query
5-34 xmlforest_expr Relation Input
5-35 xmlforest_expr Relation Output
5-36 xml_parse_expr Content: Query
5-37 xml_parse_expr Content: Relation Input
5-38 xml_parse_expr Content: Relation Output
5-39 xml_parse_expr Document: Query
5-40 xml_parse_expr Document: Relation Input
5-41 xml_parse_expr Document: Relation Output
5-42 xml_parse_expr Wellformed: Query
5-43 xml_parse_expr Wellformed: Relation Input
5-44 xml_parse_expr Wellformed: Relation Output
7-1 Declaring an Oracle CQL Data Cartridge Array in an Event Type
7-2 Accessing an Oracle CQL Data Cartridge Array in an Oracle CQL Query
7-3 attr Clause
7-4 Data Cartridge Field Access
7-5 Data Cartridge Method Access
7-6 Data Cartridge Constructor Invocation
7-7 xml_attr_list
8-1 concat Function Query
8-2 concat Function Stream Input
8-3 concat Function Relation Output
8-4 Concatenation Operator (||) Query
8-5 Concatenation Operator (||) Stream Input
8-6 Concatenation Operator (||) Relation Output
8-7 hextoraw Function Query
8-8 hextoraw Function Stream Input
8-9 hextoraw Function Relation Output
8-10 length Function Query
8-11 length Function Stream Input
8-12 length Function Relation Output
8-13 lk Function Query
8-14 lk Function Stream Input
8-15 lk Function Relation Output
8-16 nvl Function Query
8-17 nvl Function Stream Input
8-18 nvl Function Relation Output
8-19 prev(identifier1.identifier2) Function Query
8-20 prev(identifier1.identifier2) Function Stream Input
8-21 prev(identifier1.identifier2) Function Relation Output
8-22 prev(identifier1.identifier2, const_int1) Function Query
8-23 prev(identifier1.identifier2, const_int1) Function Stream Input
8-24 prev(identifier1.identifier2, const_int1) Function Relation Output
8-25 Partition Containing the Event at 8000
8-26 prev(identifier1.identifier2, const_int1, const_int2) Function Query
8-27 prev(identifier1.identifier2, const_int1, const_int2) Function Stream Input
8-28 prev(identifier1.identifier2, const_int1, const_int2) Function Relation Output
8-29 rawtohex Function Query
8-30 rawtohex Function Stream Input
8-31 rawtohex Function Relation Output
8-32 systimestamp Function Query
8-33 systimestamp Function Stream Input
8-34 systimestamp Function Relation Output
8-35 to_bigint Function Query
8-36 to_bigint Function Stream Input
8-37 to_bigint Function Relation Output
8-38 to_boolean Function Query
8-39 to_boolean Function Stream Input
8-40 to_boolean Function Relation Output
8-41 to_char Function Query
8-42 to_char Function Stream Input
8-43 to_char Function Relation Output
8-44 to_double Function Query
8-45 to_double Function Stream Input
8-46 to_double Function Relation Output
8-47 to_float Function Query
8-48 to_float Function Stream Input
8-49 to_float Function Relation Output
8-50 to_timestamp Function Query
8-51 to_timestamp Function Stream Input
8-52 to_timestamp Function Relation Output
8-53 xmlcomment Function Query
8-54 xmlcomment Function Stream Input
8-55 xmlcomment Function Relation Output
8-56 xmlconcat Function Query
8-57 xmlconcat Function Stream Input
8-58 xmlconcat Function Relation Output
8-59 xmlexists Function Query
8-60 xmlexists Function Stream Input
8-61 xmlexists Function Relation Output
8-62 xmlquery Function Query
8-63 xmlquery Function Stream Input
8-64 xmlquery Function Relation Output
9-1 Invalid Use of count
9-2 Valid Use of count
9-3 avg Function Query
9-4 avg Function Stream Input
9-5 avg Function Relation Output
9-6 count Function Query
9-7 count Function Stream Input
9-8 count Function Relation Output
9-9 first Function Query
9-10 first Function Stream Input
9-11 first Function Relation Output
9-12 last Function Query
9-13 last Function Stream Input
9-14 last Function Relation Output
9-15 max Function Query
9-16 max Function Stream Input
9-17 max Function Relation Output
9-18 min Function Query
9-19 min Function Stream Input
9-20 min Function Relation Output
9-21 sum Query
9-22 sum Stream Input
9-23 sum Relation Output
9-24 xmlagg Query
9-25 xmlagg Relation Input
9-26 xmlagg Relation Output
9-27 xmlagg and ORDER BY Query
9-28 xmlagg and ORDER BY Relation Input
9-29 xmlagg and ORDER BY Relation Output
10-1 beta Function Query
10-2 beta Function Stream Input
10-3 beta Function Relation Output
10-4 beta1 Function Query
10-5 beta1 Function Stream Input
10-6 beta1 Function Relation Output
10-7 betacomplemented Function Query
10-8 betacomplemented Function Stream Input
10-9 betacomplemented Function Relation Output
10-10 binomial Function Query
10-11 binomial Function Stream Input
10-12 binomial Function Relation Output
10-13 binomial1 Function Query
10-14 binomial1 Function Stream Input
10-15 binomial1 Function Relation Output
10-16 binomial2 Function Query
10-17 binomial2 Function Stream Input
10-18 binomial2 Function Relation Output
10-19 binomialcomplemented Function Query
10-20 binomialcomplemented Function Stream Input
10-21 binomialcomplemented Function Relation Output
10-22 bitmaskwithbitssetfromto Function Query
10-23 bitmaskwithbitssetfromto Function Stream Input
10-24 bitmaskwithbitssetfromto Function Relation Output
10-25 ceil Function Query
10-26 ceil Function Stream Input
10-27 ceil Function Relation Output
10-28 chisquare Function Query
10-29 chisquare Function Stream Input
10-30 chisquare Function Relation Output
10-31 chisquarecomplemented Function Query
10-32 chisquarecomplemented Function Stream Input
10-33 chisquarecomplemented Function Relation Output
10-34 errorfunction Function Query
10-35 errorfunction Function Stream Input
10-36 errorfunction Function Relation Output
10-37 errorfunctioncomplemented Function Query
10-38 errorfunctioncomplemented Function Stream Input
10-39 errorfunctioncomplemented Function Relation Output
10-40 factorial Function Query
10-41 factorial Function Stream Input
10-42 factorial Function Relation Output
10-43 floor Function Query
10-44 floor Function Stream Input
10-45 floor Function Relation Output
10-46 gamma Function Query
10-47 gamma Function Stream Input
10-48 gamma Function Relation Output
10-49 gamma1 Function Query
10-50 gamma1 Function Stream Input
10-51 gamma1 Function Relation Output
10-52 gammacomplemented Function Query
10-53 gammacomplemented Function Stream Input
10-54 gammacomplemented Function Relation Output
10-55 getseedatrowcolumn Function Query
10-56 getseedatrowcolumn Function Stream Input
10-57 getseedatrowcolumn Function Relation Output
10-58 hash Function Query
10-59 hash Function Stream Input
10-60 hash Function Relation Output
10-61 hash1 Function Query
10-62 hash1 Function Stream Input
10-63 hash1 Function Relation Output
10-64 hash2 Function Query
10-65 hash2 Function Stream Input
10-66 hash2 Function Relation Output
10-67 hash3 Function Query
10-68 hash3 Function Stream Input
10-69 hash3 Function Relation Output
10-70 i0 Function Query
10-71 i0 Function Stream Input
10-72 i0 Function Relation Output
10-73 i0e Function Query
10-74 i0e Function Stream Input
10-75 i0e Function Relation Output
10-76 i1 Function Query
10-77 i1 Function Stream Input
10-78 i1 Function Relation Output
10-79 i1e Function Query
10-80 i1e Function Stream Input
10-81 i1e Function Relation Output
10-82 incompletebeta Function Query
10-83 incompletebeta Function Stream Input
10-84 incompletebeta Function Relation Output
10-85 incompletegamma Function Query
10-86 incompletegamma Function Stream Input
10-87 incompletegamma Function Relation Output
10-88 incompletegammacomplement Function Query
10-89 incompletegammacomplement Function Stream Input
10-90 incompletegammacomplement Function Relation Output
10-91 j0 Function Query
10-92 j0 Function Stream Input
10-93 j0 Function Relation Output
10-94 j1 Function Query
10-95 j1 Function Stream Input
10-96 j1 Function Relation Output
10-97 jn Function Query
10-98 jn Function Stream Input
10-99 jn Function Relation Output
10-100 k0 Function Query
10-101 k0 Function Stream Input
10-102 k0 Function Relation Output
10-103 k0e Function Query
10-104 k0e Function Stream Input
10-105 k0e Function Relation Output
10-106 k1 Function Query
10-107 k1 Function Stream Input
10-108 k1 Function Relation Output
10-109 k1e Function Query
10-110 k1e Function Stream Input
10-111 k1e Function Relation Output
10-112 kn Function Query
10-113 kn Function Stream Input
10-114 kn Function Relation Output
10-115 leastsignificantbit Function Query
10-116 leastsignificantbit Function Stream Input
10-117 leastsignificantbit Function Relation Output
10-118 log Function Query
10-119 log Function Stream Input
10-120 log Function Relation Output
10-121 log10 Function Query
10-122 log10 Function Stream Input
10-123 log10 Function Relation Output
10-124 log2 Function Query
10-125 log2 Function Stream Input
10-126 log2 Function Relation Output
10-127 logfactorial Function Query
10-128 logfactorial Function Stream Input
10-129 logfactorial Function Relation Output
10-130 loggamma Function Query
10-131 loggamma Function Stream Input
10-132 loggamma Function Relation Output
10-133 longfactorial Function Query
10-134 longfactorial Function Stream Input
10-135 longfactorial Function Relation Output
10-136 mostsignificantbit Function Query
10-137 mostsignificantbit Function Stream Input
10-138 mostsignificantbit Function Relation Output
10-139 negativebinomial Function Query
10-140 negativebinomial Function Stream Input
10-141 negativebinomial Function Relation Output
10-142 negativebinomialcomplemented Function Query
10-143 negativebinomialcomplemented Function Stream Input
10-144 negativebinomialcomplemented Function Relation Output
10-145 normal Function Query
10-146 normal Function Stream Input
10-147 normal Function Relation Output
10-148 normal1 Function Query
10-149 normal1 Function Stream Input
10-150 normal1 Function Relation Output
10-151 normalinverse Function Query
10-152 normalinverse Function Stream Input
10-153 normalinverse Function Relation Output
10-154 poisson Function Query
10-155 poisson Function Stream Input
10-156 poisson Function Relation Output
10-157 poissoncomplemented Function Query
10-158 poissoncomplemented Function Stream Input
10-159 poissoncomplemented Function Relation Output
10-160 stirlingcorrection Function Query
10-161 stirlingcorrection Function Stream Input
10-162 stirlingcorrection Function Relation Output
10-163 studentt Function Query
10-164 studentt Function Stream Input
10-165 studentt Function Relation Output
10-166 studenttinverse Function Query
10-167 studenttinverse Function Stream Input
10-168 studenttinverse Function Relation Output
10-169 y0 Function Query
10-170 y0 Function Stream Input
10-171 y0 Function Relation Output
10-172 y1 Function Query
10-173 y1 Function Stream Input
10-174 y1 Function Relation Output
10-175 yn Function Query
10-176 yn Function Stream Input
10-177 yn Function Relation Output
11-1 Invalid Use of count
11-2 Valid Use of count
11-3 autocorrelation Function Query
11-4 autocorrelation Function Stream Input
11-5 autocorrelation Function Relation Output
11-6 correlation Function Query
11-7 correlation Function Stream Input
11-8 correlation Function Relation Output
11-9 covariance Function Query
11-10 covariance Function Stream Input
11-11 covariance Function Relation Output
11-12 geometricmean Function Query
11-13 geometricmean Function Stream Input
11-14 geometricmean Function Relation Output
11-15 geometricmean1 Function Query
11-16 geometricmean1 Function Stream Input
11-17 geometricmean1 Function Relation Output
11-18 harmonicmean Function Query
11-19 harmonicmean Function Stream Input
11-20 harmonicmean Function Relation Output
11-21 kurtosis Function Query
11-22 kurtosis Function Stream Input
11-23 kurtosis Function Relation Output
11-24 lag1 Function Query
11-25 lag1 Function Stream Input
11-26 lag1 Function Relation Output
11-27 mean Function Query
11-28 mean Function Stream Input
11-29 mean Function Relation Output
11-30 meandeviation Function Query
11-31 meandeviation Function Stream Input
11-32 meandeviation Function Relation Output
11-33 median Function Query
11-34 median Function Stream Input
11-35 median Function Relation Output
11-36 moment Function Query
11-37 moment Function Stream Input
11-38 moment Function Relation Output
11-39 pooledmean Function Query
11-40 pooledmean Function Stream Input
11-41 pooledmean Function Relation Output
11-42 pooledvariance Function Query
11-43 pooledvariance Function Stream Input
11-44 pooledvariance Function Relation Output
11-45 product Function Query
11-46 product Function Stream Input
11-47 product Function Relation Output
11-48 quantile Function Query
11-49 quantile Function Stream Input
11-50 quantile Function Relation Output
11-51 quantileinverse Function Query
11-52 quantileinverse Function Stream Input
11-53 quantileinverse Function Relation Output
11-54 rankinterpolated Function Query
11-55 rankinterpolated Function Stream Input
11-56 rankinterpolated Function Relation Output
11-57 rms Function Query
11-58 rms Function Stream Input
11-59 rms Function Relation Output
11-60 samplekurtosis Function Query
11-61 samplekurtosis Function Stream Input
11-62 samplekurtosis Function Relation Output
11-63 samplekurtosisstandarderror Function Query
11-64 samplekurtosisstandarderror Function Stream Input
11-65 samplekurtosisstandarderror Function Relation Output
11-66 sampleskew Function Query
11-67 sampleskew Function Stream Input
11-68 sampleskew Function Relation Output
11-69 sampleskewstandarderror Function Query
11-70 sampleskewstandarderror Function Stream Input
11-71 sampleskewstandarderror Function Relation Output
11-72 samplevariance Function Query
11-73 samplevariance Function Stream Input
11-74 samplevariance Function Relation Output
11-75 skew Function Query
11-76 skew Function Stream Input
11-77 skew Function Relation Output
11-78 standarddeviation Function Query
11-79 standarddeviation Function Stream Input
11-80 standarddeviation Function Relation Output
11-81 standarderror Function Query
11-82 standarderror Function Stream Input
11-83 standarderror Function Relation Output
11-84 sumofinversions Function Query
11-85 sumofinversions Function Stream Input
11-86 sumofinversions Function Relation Output
11-87 sumoflogarithms Function Query
11-88 sumoflogarithms Function Stream Input
11-89 sumoflogarithms Function Relation Output
11-90 sumofpowerdeviations Function Query
11-91 sumofpowerdeviations Function Stream Input
11-92 sumofpowerdeviations Function Relation Output
11-93 sumofpowers Function Query
11-94 sumofpowers Function Stream Input
11-95 sumofpowers Function Relation Output
11-96 sumofsquareddeviations Function Query
11-97 sumofsquareddeviations Function Stream Input
11-98 sumofsquareddeviations Function Relation Output
11-99 sumofsquares Function Query
11-100 sumofsquares Function Stream Input
11-101 sumofsquares Function Relation Output
11-102 trimmedmean Function Query
11-103 trimmedmean Function Stream Input
11-104 trimmedmean Function Relation Output
11-105 variance Function Query
11-106 variance Function Stream Input
11-107 variance Function Relation Output
11-108 weightedmean Function Query
11-109 weightedmean Function Stream Input
11-110 weightedmean Function Relation Output
11-111 winsorizedmean Function Query
11-112 winsorizedmean Function Stream Input
11-113 winsorizedmean Function Relation Output
12-1 abs Function Query
12-2 abs Function Stream Input
12-3 abs Function Stream Output
12-4 abs1 Function Query
12-5 abs1 Function Stream Input
12-6 abs1 Function Stream Output
12-7 abs2 Function Query
12-8 abs2 Function Stream Input
12-9 abs2 Function Stream Output
12-10 abs3 Function Query
12-11 abs3 Function Stream Input
12-12 abs3 Function Stream Output
12-13 acos Function Query
12-14 acos Function Stream Input
12-15 acos Function Stream Output
12-16 asin Function Query
12-17 asin Function Stream Input
12-18 asin Function Stream Output
12-19 atan Function Query
12-20 atan Function Stream Input
12-21 atan Function Stream Output
12-22 atan2 Function Query
12-23 atan2 Function Stream Input
12-24 atan2 Function Stream Output
12-25 cbrt Function Query
12-26 cbrt Function Stream Input
12-27 cbrt Function Stream Output
12-28 ceil1 Function Query
12-29 ceil1 Function Stream Input
12-30 ceil1 Function Stream Output
12-31 cos Function Query
12-32 cos Function Stream Input
12-33 cos Function Stream Output
12-34 cosh Function Query
12-35 cosh Function Stream Input
12-36 cosh Function Stream Output
12-37 exp Function Query
12-38 exp Function Stream Input
12-39 exp Function Stream Output
12-40 expm1 Function Query
12-41 expm1 Function Stream Input
12-42 expm1 Function Stream Output
12-43 floor1 Function Query
12-44 floor1 Function Stream Input
12-45 floor1 Function Stream Output
12-46 hypot Function Query
12-47 hypot Function Stream Input
12-48 hypot Function Stream Output
12-49 ieeeremainder Function Query
12-50 ieeeremainder Function Stream Input
12-51 ieeeremainder Function Stream Output
12-52 log1 Function Query
12-53 log1 Function Stream Input
12-54 log1 Function Stream Output
12-55 log101 Function Query
12-56 log101 Function Stream Input
12-57 log101 Function Stream Output
12-58 log1p Function Query
12-59 log1p Function Stream Input
12-60 log1p Function Stream Output
12-61 pow Function Query
12-62 pow Function Stream Input
12-63 pow Function Stream Output
12-64 rint Function Query
12-65 rint Function Stream Input
12-66 rint Function Stream Output
12-67 round Function Query
12-68 round Function Stream Input
12-69 round Function Stream Output
12-70 round1 Function Query
12-71 round1 Function Stream Input
12-72 round1 Function Stream Output
12-73 signum Function Query
12-74 signum Function Stream Input
12-75 signum Function Stream Output
12-76 signum1 Function Query
12-77 signum1 Function Stream Input
12-78 signum1 Function Relation Output
12-79 sin Function Query
12-80 sin Function Stream Input
12-81 sin Function Stream Output
12-82 sinh Function Query
12-83 sinh Function Stream Input
12-84 sinh Function Stream Output
12-85 sqrt Function Query
12-86 sqrt Function Stream Input
12-87 sqrt Function Stream Output
12-88 tan Function Query
12-89 tan Function Stream Input
12-90 tan Function Stream Output
12-91 tanh Function Query
12-92 tanh Function Stream Input
12-93 tanh Function Stream Output
12-94 todegrees Function Query
12-95 todegrees Function Stream Input
12-96 todegrees Function Stream Output
12-97 toradians Function Query
12-98 toradians Function Stream Input
12-99 toradians Function Stream Output
12-100 ulp Function Query
12-101 ulp Function Stream Input
12-102 ulp Function Stream Output
12-103 ulp1 Function Query
12-104 ulp1 Function Stream Input
12-105 ulp1 Function Relation Output
13-1 MyMod.java User-Defined Single-Row Function
13-2 Single-Row User Defined Function for an Oracle CQL Processor
13-3 Accessing a User-Defined Single-Row Function in Oracle CQL
13-4 Variance.java User-Defined Aggregate Function
13-5 Aggregate User Defined Function for an Oracle CQL Processor
13-6 Accessing a User-Defined Aggregate Function in Oracle CQL
15-1 Address.java Class
15-2 Event Type Repository
15-3 Channel
15-4 Oracle CQL Query
15-5 Address.java Class
15-6 Event Type Repository
15-7 Channel
15-8 Oracle CQL Query
16-1 spatial:context Element in EPN Assembly File
16-2 Referencing spatial:context in an Oracle CQL Query
16-3 Oracle CQL Query Using Oracle Spatial Geometry Types
16-4 Creating a Point Geometry Using a Geometry Static Method
16-5 Accessing Geometry Type Public Methods and Fields
16-6 Using Geometry Relation Operators
16-7 Using Geometry Filter Operators
16-8 Using the Default Geodetic Coordinates in an Oracle CQL Query
16-9 spatial:context Element in EPN Assembly File
16-10 Referencing spatial:context in an Oracle CQL Query
16-11 Oracle CQL Query Using Geometry.bufferPolygon
16-12 Oracle CQL Query Using Geometry.createElemInfo
16-13 Oracle CQL Query Using Geometry.createGeometry
16-14 Oracle CQL Query Using Geometry.createLinearPolygon
16-15 Oracle CQL Query Using Geometry.createPoint
16-16 Oracle CQL Query Using Geometry.createRectangle
16-17 Oracle CQL Query Using Geometry.distance
16-18 Oracle CQL Query Using Oracle Spatial Geometry Types
16-19 Oracle CQL Query Using Geometry.get2dMbr
16-20 Oracle CQL Query Using Oracle Spatial Geometry Types
16-21 Oracle CQL Query Using Geometry.to_Geometry
16-22 Oracle CQL Query Using Geometry.to_JGeometry
17-1 Typical Oracle CQL Query
17-2 Fully Qualified Stream Element Names
17-3 Simple Query
17-4 Built-In Window Query
17-5 MATCH_RECOGNIZE Query
17-6 Table Create SQL Statement
17-7 Oracle CQL Query on Relational Database Table Stock
17-8 XMLTABLE Query
17-9 Data Cartridge TABLE Query
17-10 Invalid Data Cartridge TABLE Query
17-11 DIFFERENCE USING Clause
17-12 Specifying the usinglist in a DIFFERENCE USING Clause
17-13 Using Views Instead of Subqueries
17-14 Using View Names to Distinguish Between Stream Elements of the Same Name
17-15 Schema With Event Attribute Names Only
17-16 Fully Qualified Stream Element Names
17-17 Inner Joins
17-18 Outer Joins
17-19 Left Outer Joins
17-20 Right Outer Joins
17-21 Outer Join Look-Back
18-1 Pattern Matching Conditions
18-2 ALL MATCHES Clause Query
18-3 ALL MATCHES Clause Stream Input
18-4 ALL MATCHES Clause Stream Output
18-5 Undefined Correlation Name
18-6 MATCH_RECOGNIZE with Fixed Duration DURATION Clause Query
18-7 MATCH_RECOGNIZE with Fixed Duration DURATION Clause Stream Input
18-8 MATCH_RECOGNIZE with Fixed DURATION Clause Stream Output
18-9 MATCH_RECOGNIZE with Variable Duration DURATION MULTIPLES OF Clause Query
18-10 MATCH_RECOGNIZE with Variable Duration DURATION MULTIPLES OF Clause Stream Input
18-11 MATCH_RECOGNIZE with Variable Duration DURATION MULTIPLES OF Clause Stream Output
18-12 Input Stream S1
18-13 MATCH_RECOGNIZE Query Using Input Stream S1
18-14 MATCH_RECOGNIZE with SUBSET Clause Query
18-15 MATCH_RECOGNIZE with SUBSET Clause Stream Input
18-16 MATCH_RECOGNIZE with SUBSET Clause Stream Output
18-17 Simple Pattern Detection: Query
18-18 Pattern Detection With Partition By: Query
18-19 Pattern Detection With Aggregates: Query
18-20 Pattern Detection With Aggregates: Stream Input
18-21 Pattern Detection With Aggregates: Stream Output
18-22 PATTERN Clause and WITHIN Clause
18-23 PATTERN Clause and WITHIN INCLUSIVE Clause
18-24 Pattern Detection With the WITHIN Clause: Stream Input
18-25 Fixed Duration Non-Event Detection: Query
19-1 Query in a <query></query> Element
19-2 Specifying the usinglist in a DIFFERENCE USING Clause
19-3 REGISTER QUERY
19-4 HAVING Query
19-5 HAVING Stream Input
19-6 HAVING Relation Output
19-7 Set Operators: UNION Query
19-8 Set Operators: UNION Relation Input R1
19-9 Set Operators: UNION Relation Input R2
19-10 Set Operators: UNION Relation Output
19-11 Set Operators: UNION ALL Relation Output
19-12 Set Operators: INTERSECT Query
19-13 Set Operators: INTERSECT Relation Input R1
19-14 Set Operators: INTERSECT Relation Input R2
19-15 Set Operators: INTERSECT Relation Output
19-16 Set Operators: MINUS Query
19-17 Set Operators: MINUS Relation Input R1
19-18 Set Operators: MINUS Relation Input R2
19-19 Set Operators: MINUS Relation Output
19-20 Select DISTINCT Query
19-21 Select DISTINCT Stream Input
19-22 Select DISTINCT Stream Output
19-23 XMLTABLE Query
19-24 XMLTABLE Stream Input
19-25 XMLTABLE Relation Output
19-26 XMLTABLE With XML Namespaces Query
19-27 XMLTABLE With XML Namespaces Stream Input
19-28 XMLTABLE With XML Namespaces Relation Output
19-29 MyCartridge Method getIterator
19-30 TABLE Query: Iterator
19-31 TABLE Query Stream Input: Iterator
19-32 TABLE Query Output: Iterator
19-33 MyCartridge Method getArray
19-34 TABLE Query: Array
19-35 TABLE Query Stream Input: Array
19-36 TABLE Query Output: Array
19-37 MyCartridge Method getCollection
19-38 TABLE Query: Collection
19-39 TABLE Query Stream Input: Collection
19-40 TABLE Query Output: Collection
19-41 ORDER BY ROWS Query
19-42 ORDER BY ROWS Stream Input
19-43 ORDER BY ROWS Output
19-44 View in a <view></view> Element
19-45 REGISTER VIEW
Scripting on this page enhances content navigation, but does not change the content in any way.