Skip Headers
Oracle® Fusion Middleware CQL Language Reference for Oracle Complex Event Processing
11
g
Release 1 (11.1.1.6.0)
Part Number E12048-06
Home
Book List
Contents
Index
Master Index
Contact Us
Previous
Next
PDF
·
Mobi
·
ePub
List of Examples
1-1 Typical Oracle CQL Statements
1-2 Stock Ticker Data Stream
1-3 Channel Schema Definition
1-4 filterFanoutProcessor Oracle CQL Query Using priceStream
1-5 Using channel Element selector Child Element to Control Which Query Results are Output to a Channel
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 Alternation Operator (|)
4-3 S [now] Query
4-4 S [now] Stream Input
4-5 S [now] Relation Output at Time 5000000000 ns
4-6 S [range T] Query
4-7 S [range T] Stream Input
4-8 S [range T] Relation Output
4-9 S [range T1 slide T2] Query
4-10 S [range T1 slide T2] Stream Input
4-11 S [range T1 slide T2] Relation Output
4-12 S [range unbounded] Query
4-13 S [range unbounded] Stream Input
4-14 S [range unbounded] Relation Output at Time 5000 ms
4-15 S [range unbounded] Relation Output at Time 205000 ms
4-16 S [range C on E] Constant Value: Query
4-17 S [range C on E] Constant Value: Stream Input
4-18 S [range C on E] Constant Value: Relation Output
4-19 S [range C on E] INTERVAL Value: Query
4-20 S [range C on E] INTERVAL Value: Stream Input
4-21 S [range C on E] INTERVAL Value: Relation Output
4-22 S [rows N] Query
4-23 S [rows N] Stream Input
4-24 S [rows N] Relation Output at Time 1003 ms
4-25 S [rows N] Relation Output at Time 1007 ms
4-26 S [rows N] Relation Output at Time 2001 ms
4-27 S [rows N1 slide N2] Query
4-28 S [rows N1 slide N2] Stream Input
4-29 S [rows N1 slide N2] Relation Output
4-30 S[partition by A1, ..., Ak rows N] Query
4-31 S[partition by A1, ..., Ak rows N] Stream Input
4-32 S[partition by A1, ..., Ak rows N] Relation Output
4-33 S[partition by A1, ..., Ak rows N range T] Query
4-34 S[partition by A1, ..., Ak rows N range T] Stream Input
4-35 S[partition by A1, ..., Ak rows N range T] Relation Output
4-36 S[partition by A1, ..., Ak rows N range T1 slide T2] Query
4-37 S[partition by A1, ..., Ak rows N range T1 slide T2] Stream Input
4-38 S[partition by A1, ..., Ak rows N range T1 slide T2] Relation Output
4-39 IStream
4-40 DStream
4-41 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
6-1 S [range C on E] INTERVAL Value: Query
6-2 S [range C on E] INTERVAL Value: Stream Input
6-3 S [range C on E] INTERVAL Value: 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 EPN Assembly File: Oracle Spatial Namespace and Schema Location
16-2 spatial:context Element in EPN Assembly File
16-3 Referencing spatial:context in an Oracle CQL Query
16-4 Oracle CEP Event Using Oracle Spatial Types
16-5 Oracle CQL Query Using Oracle Spatial Geometry Types
16-6 Creating a Point Geometry Using a Geometry Static Method
16-7 Accessing Geometry Type Public Methods and Fields
16-8 Using Geometry Relation Operators
16-9 Using Geometry Filter Operators
16-10 Using the Default Geodetic Coordinates in an Oracle CQL Query
16-11 spatial:context Element in EPN Assembly File
16-12 Referencing spatial:context in an Oracle CQL Query
16-13 Oracle CQL Query Using Geometric Relation Operator ANYINTERACT
16-14 Oracle CQL Query Using Geometry.bufferPolygon
16-15 Oracle CQL Query Using Geometric Relation Operator CONTAIN
16-16 Oracle CQL Query Using Geometry.createElemInfo
16-17 Oracle CQL Query Using Geometry.createGeometry
16-18 Oracle CQL Query Using Geometry.createLinearPolygon
16-19 Oracle CQL Query Using Geometry.createPoint
16-20 Oracle CQL Query Using Geometry.createRectangle
16-21 Oracle CQL Query Using Geometry.distance
16-22 Oracle CQL Query Using Oracle Spatial Geometry Types
16-23 Oracle CQL Query Using Geometric Relation Operator FILTER
16-24 Oracle CQL Query Using Geometry.get2dMbr
16-25 Oracle CQL Query Using Geometric Relation Operator INSIDE
16-26 Oracle CQL Query Using Geometric Relation Operator NN
16-27 Oracle CQL Query Using Oracle Spatial Geometry Types
16-28 Oracle CQL Query Using Geometry.to_Geometry
16-29 Oracle CQL Query Using Geometry.to_JGeometry
16-30 Oracle CQL Query Using Geometric Relation Operator WITHINDISTANCE
17-1 Oracle CEP JDBC Data Cartridge SQL Statement
17-2 EPN Assembly File: Oracle CEP JDBC Data Cartridge Namespace and Schema Location
17-3 jdbc:jdbc-context Element in EPN Assembly File
17-4 jc:jdbc-ctx Element in Component Configuration File
17-5 Example return-component-type Class
17-6 Oracle CEP JDBC Data Cartridge SQL Statement
17-7 Oracle JDBC Data Cartridge Context Functions With Multiple Parameters
17-8 Oracle JDBC Data Cartridge Context Function Invoking PL/SQL Functions
17-9 Oracle CEP JDBC Data Cartridge Complex JDBC Cartridge Context Function
17-10 Oracle JDBC Data Cartridge Context Function Overloading
17-11 Oracle CEP JDBC Data Cartridge Context Function
17-12 Oracle CEP JDBC Data Cartridge SQL Statement
17-13 Oracle CQL Query Invoking an Oracle CEP JDBC Data Cartridge Context Function
17-14 Example return-component-type Class
17-15 CQL Type bigint as a return-component-type
17-16 getOrderAmt Function in a CQL Query
18-1 Typical Oracle CQL Query
18-2 Fully Qualified Stream Element Names
18-3 Simple Query
18-4 Built-In Window Query
18-5 MATCH_RECOGNIZE Query
18-6 XMLTABLE Query
18-7 Data Cartridge TABLE Query
18-8 Invalid Data Cartridge TABLE Query
18-9 DIFFERENCE USING Clause
18-10 Specifying the usinglist in a DIFFERENCE USING Clause
18-11 Parameterized Oracle CQL Query
18-12 Equivalent Queries at Runtime
18-13 Using Views Instead of Subqueries
18-14 Using View Names to Distinguish Between Stream Elements of the Same Name
18-15 Schema With Event Attribute Names Only
18-16 Fully Qualified Stream Element Names
18-17 Inner Joins
18-18 Outer Joins
18-19 Left Outer Joins
18-20 Right Outer Joins
18-21 Outer Join Look-Back
19-1 Pattern Matching With MATCH_RECOGNIZE
19-2 MATCH_RECOGNIZE and the WHERE Clause
19-3 Implied Running Aggregate
19-4 Invalid Use of Aggregate Function
19-5 Referencing a Variable That has not Been Matched Yet: Invalid
19-6 Referencing a Variable That has not Been Matched Yet: Valid
19-7 Referencing Attributes not Qualified by Correlation Variable
19-8 MATCH_RECOGNIZE Query Using count(A.*)
19-9 Use of the prev Function: Valid
19-10 Use of the prev Function: Invalid
19-11 Using Functions Over Correlation Variables
19-12 Using Functions Over Correlation Variables: to_timestamp
19-13 Using Functions Over Correlation Variables: count
19-14 Undefined Correlation Name
19-15 Referencing One Correlation Variable From Another
19-16 Input Stream S1
19-17 MATCH_RECOGNIZE Query Using Input Stream S1
19-18 ALL MATCHES Clause Query
19-19 ALL MATCHES Clause Stream Input
19-20 ALL MATCHES Clause Stream Output
19-21 MATCH_RECOGNIZE with Fixed Duration DURATION Clause Query
19-22 MATCH_RECOGNIZE with Fixed Duration DURATION Clause Stream Input
19-23 MATCH_RECOGNIZE with Fixed DURATION Clause Stream Output
19-24 MATCH_RECOGNIZE with Variable Duration DURATION MULTIPLES OF Clause Query
19-25 MATCH_RECOGNIZE with Variable Duration DURATION MULTIPLES OF Clause Stream Input
19-26 MATCH_RECOGNIZE with Variable Duration DURATION MULTIPLES OF Clause Stream Output
19-27 MATCH_RECOGNIZE with SUBSET Clause Query
19-28 MATCH_RECOGNIZE with SUBSET Clause Stream Input
19-29 MATCH_RECOGNIZE with SUBSET Clause Stream Output
19-30 Simple Pattern Detection: Query
19-31 Pattern Detection With PARTITION BY: Query
19-32 Pattern Detection With Aggregates: Query
19-33 Pattern Detection With Aggregates: Stream Input
19-34 Pattern Detection With Aggregates: Stream Output
19-35 PATTERN Clause and WITHIN Clause
19-36 PATTERN Clause and WITHIN INCLUSIVE Clause
19-37 Pattern Detection With the WITHIN Clause: Stream Input
19-38 Fixed Duration Non-Event Detection: Query
20-1 Query in a <query></query> Element
20-2 Specifying the usinglist in a DIFFERENCE USING Clause
20-3 REGISTER QUERY
20-4 HAVING Query
20-5 HAVING Stream Input
20-6 HAVING Relation Output
20-7 Set Operators: UNION Query
20-8 Set Operators: UNION Relation Input R1
20-9 Set Operators: UNION Relation Input R2
20-10 Set Operators: UNION Relation Output
20-11 Set Operators: UNION ALL Relation Output
20-12 Set Operators: INTERSECT Query
20-13 Set Operators: INTERSECT Relation Input R1
20-14 Set Operators: INTERSECT Relation Input R2
20-15 Set Operators: INTERSECT Relation Output
20-16 Set Operators: MINUS Query
20-17 Set Operators: MINUS Relation Input R1
20-18 Set Operators: MINUS Relation Input R2
20-19 Set Operators: MINUS Relation Output
20-20 IN and NOT IN as a Set Operation: Query
20-21 IN and NOT IN as a Set Operation: Stream S3 Input
20-22 IN and NOT IN as a Set Operation: Stream S4 Input
20-23 IN and NOT IN as a Set Operation: Relation Output
20-24 Select DISTINCT Query
20-25 Select DISTINCT Stream Input
20-26 Select DISTINCT Stream Output
20-27 XMLTABLE Query
20-28 XMLTABLE Stream Input
20-29 XMLTABLE Relation Output
20-30 XMLTABLE With XML Namespaces Query
20-31 XMLTABLE With XML Namespaces Stream Input
20-32 XMLTABLE With XML Namespaces Relation Output
20-33 MyCartridge Method getIterator
20-34 TABLE Query: Iterator
20-35 TABLE Query Stream Input: Iterator
20-36 TABLE Query Output: Iterator
20-37 MyCartridge Method getArray
20-38 TABLE Query: Array
20-39 TABLE Query Stream Input: Array
20-40 TABLE Query Output: Array
20-41 MyCartridge Method getCollection
20-42 TABLE Query: Collection
20-43 TABLE Query Stream Input: Collection
20-44 TABLE Query Output: Collection
20-45 ORDER BY ROWS Query
20-46 ORDER BY ROWS Stream Input
20-47 ORDER BY ROWS Output
20-48 View in a <view></view> Element
20-49 REGISTER VIEW
Scripting on this page enhances content navigation, but does not change the content in any way.