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 Relation-to-Stream Operation
• 1-9 Stream-to-Stream Operation
• 1-10 Typical Oracle CQL Processor Configuration Source File
• 1-11 Oracle CQL: Without Whitespace Formatting
• 1-12 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 Comapring Intervals
• 2-10 Using the AS Operator in the SELECT Statement
• 2-11 Using the AS Operator After a Window Operator
• 3-1 ELEMENT_TIME Pseudocolumn in a Select Statement
• 3-2 Input Stream
• 3-3 Output Relation
• 3-4 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 concat Function Query
• 5-2 concat Function Stream Input
• 5-3 concat Function Relation Output
• 5-4 Concatenation Operator (||) Query
• 5-5 Concatenation Operator (||) Stream Input
• 5-6 Concatenation Operator (||) Relation Output
• 5-7 hextoraw Function Query
• 5-8 hextoraw Function Stream Input
• 5-9 hextoraw Function Relation Output
• 5-10 length Function Query
• 5-11 length Function Stream Input
• 5-12 length Function Relation Output
• 5-13 lk Function Query
• 5-14 lk Function Stream Input
• 5-15 lk Function Relation Output
• 5-16 nvl Function Query
• 5-17 nvl Function Stream Input
• 5-18 nvl Function Relation Output
• 5-19 prev(identifier1.identifier2) Function Query
• 5-20 prev(identifier1.identifier2) Function Stream Input
• 5-21 prev(identifier1.identifier2) Function Relation Output
• 5-22 prev(identifier1.identifier2, const_int1) Function Query
• 5-23 prev(identifier1.identifier2, const_int1) Function Stream Input
• 5-24 prev(identifier1.identifier2, const_int1) Function Relation Output
• 5-25 prev(identifier1.identifier2, const_int1, const_int2) Function Query
• 5-26 prev(identifier1.identifier2, const_int1, const_int2) Function Stream Input
• 5-27 prev(identifier1.identifier2, const_int1, const_int2) Function Relation Output
• 5-28 rawtohex Function Query
• 5-29 rawtohex Function Stream Input
• 5-30 rawtohex Function Relation Output
• 5-31 systimestamp Function Query
• 5-32 systimestamp Function Stream Input
• 5-33 systimestamp Function Relation Output
• 5-34 to_bigint Function Query
• 5-35 to_bigint Function Stream Input
• 5-36 to_bigint Function Relation Output
• 5-37 to_boolean Function Query
• 5-38 to_boolean Function Stream Input
• 5-39 to_boolean Function Relation Output
• 5-40 to_char Function Query
• 5-41 to_char Function Stream Input
• 5-42 to_char Function Relation Output
• 5-43 to_double Function Query
• 5-44 to_double Function Stream Input
• 5-45 to_double Function Relation Output
• 5-46 to_float Function Query
• 5-47 to_float Function Stream Input
• 5-48 to_float Function Relation Output
• 5-49 to_timestamp Function Query
• 5-50 to_timestamp Function Stream Input
• 5-51 to_timestamp Function Relation Output
• 5-52 xmlcomment Function Query
• 5-53 xmlcomment Function Stream Input
• 5-54 xmlcomment Function Relation Output
• 5-55 xmlconcat Function Query
• 5-56 xmlconcat Function Stream Input
• 5-57 xmlconcat Function Relation Output
• 5-58 xmlexists Function Query
• 5-59 xmlexists Function Stream Input
• 5-60 xmlexists Function Relation Output
• 5-61 xmlquery Function Query
• 5-62 xmlquery Function Stream Input
• 5-63 xmlquery Function Relation Output
• 6-1 avg Function Query
• 6-2 avg Function Stream Input
• 6-3 avg Function Relation Output
• 6-4 count Function Query
• 6-5 count Function Stream Input
• 6-6 count Function Relation Output
• 6-7 first Function Query
• 6-8 first Function Stream Input
• 6-9 first Function Relation Output
• 6-10 last Function Query
• 6-11 last Function Stream Input
• 6-12 last Function Relation Output
• 6-13 max Function Query
• 6-14 max Function Stream Input
• 6-15 max Function Relation Output
• 6-16 min Function Query
• 6-17 min Function Stream Input
• 6-18 min Function Relation Output
• 6-19 sum Query
• 6-20 sum Stream Input
• 6-21 sum Relation Output
• 6-22 xmlagg Query
• 6-23 xmlagg Relation Input
• 6-24 xmlagg Relation Output
• 6-25 xmlagg and ORDER BY Query
• 6-26 xmlagg and ORDER BY Relation Input
• 6-27 xmlagg and ORDER BY Relation Output
• 7-1 beta Function Query
• 7-2 beta Function Stream Input
• 7-3 beta Function Relation Output
• 7-4 beta1 Function Query
• 7-5 beta1 Function Stream Input
• 7-6 beta1 Function Relation Output
• 7-7 betacomplemented Function Query
• 7-8 betacomplemented Function Stream Input
• 7-9 betacomplemented Function Relation Output
• 7-10 binomial Function Query
• 7-11 binomial Function Stream Input
• 7-12 binomial Function Relation Output
• 7-13 binomial1 Function Query
• 7-14 binomial1 Function Stream Input
• 7-15 binomial1 Function Relation Output
• 7-16 binomial2 Function Query
• 7-17 binomial2 Function Stream Input
• 7-18 binomial2 Function Relation Output
• 7-19 binomialcomplemented Function Query
• 7-20 binomialcomplemented Function Stream Input
• 7-21 binomialcomplemented Function Relation Output
• 7-22 bitmaskwithbitssetfromto Function Query
• 7-23 bitmaskwithbitssetfromto Function Stream Input
• 7-24 bitmaskwithbitssetfromto Function Relation Output
• 7-25 ceil Function Query
• 7-26 ceil Function Stream Input
• 7-27 ceil Function Relation Output
• 7-28 chisquare Function Query
• 7-29 chisquare Function Stream Input
• 7-30 chisquare Function Relation Output
• 7-31 chisquarecomplemented Function Query
• 7-32 chisquarecomplemented Function Stream Input
• 7-33 chisquarecomplemented Function Relation Output
• 7-34 errorfunction Function Query
• 7-35 errorfunction Function Stream Input
• 7-36 errorfunction Function Relation Output
• 7-37 errorfunctioncomplemented Function Query
• 7-38 errorfunctioncomplemented Function Stream Input
• 7-39 errorfunctioncomplemented Function Relation Output
• 7-40 factorial Function Query
• 7-41 factorial Function Stream Input
• 7-42 factorial Function Relation Output
• 7-43 floor Function Query
• 7-44 floor Function Stream Input
• 7-45 floor Function Relation Output
• 7-46 gamma Function Query
• 7-47 gamma Function Stream Input
• 7-48 gamma Function Relation Output
• 7-49 gamma1 Function Query
• 7-50 gamma1 Function Stream Input
• 7-51 gamma1 Function Relation Output
• 7-52 gammacomplemented Function Query
• 7-53 gammacomplemented Function Stream Input
• 7-54 gammacomplemented Function Relation Output
• 7-55 getseedatrowcolumn Function Query
• 7-56 getseedatrowcolumn Function Stream Input
• 7-57 getseedatrowcolumn Function Relation Output
• 7-58 hash Function Query
• 7-59 hash Function Stream Input
• 7-60 hash Function Relation Output
• 7-61 hash1 Function Query
• 7-62 hash1 Function Stream Input
• 7-63 hash1 Function Relation Output
• 7-64 hash2 Function Query
• 7-65 hash2 Function Stream Input
• 7-66 hash2 Function Relation Output
• 7-67 hash3 Function Query
• 7-68 hash3 Function Stream Input
• 7-69 hash3 Function Relation Output
• 7-70 i0 Function Query
• 7-71 i0 Function Stream Input
• 7-72 i0 Function Relation Output
• 7-73 i0e Function Query
• 7-74 i0e Function Stream Input
• 7-75 i0e Function Relation Output
• 7-76 i1 Function Query
• 7-77 i1 Function Stream Input
• 7-78 i1 Function Relation Output
• 7-79 i1e Function Query
• 7-80 i1e Function Stream Input
• 7-81 i1e Function Relation Output
• 7-82 incompletebeta Function Query
• 7-83 incompletebeta Function Stream Input
• 7-84 incompletebeta Function Relation Output
• 7-85 incompletegamma Function Query
• 7-86 incompletegamma Function Stream Input
• 7-87 incompletegamma Function Relation Output
• 7-88 incompletegammacomplement Function Query
• 7-89 incompletegammacomplement Function Stream Input
• 7-90 incompletegammacomplement Function Relation Output
• 7-91 j0 Function Query
• 7-92 j0 Function Stream Input
• 7-93 j0 Function Relation Output
• 7-94 j1 Function Query
• 7-95 j1 Function Stream Input
• 7-96 j1 Function Relation Output
• 7-97 jn Function Query
• 7-98 jn Function Stream Input
• 7-99 jn Function Relation Output
• 7-100 k0 Function Query
• 7-101 k0 Function Stream Input
• 7-102 k0 Function Relation Output
• 7-103 k0e Function Query
• 7-104 k0e Function Stream Input
• 7-105 k0e Function Relation Output
• 7-106 k1 Function Query
• 7-107 k1 Function Stream Input
• 7-108 k1 Function Relation Output
• 7-109 k1e Function Query
• 7-110 k1e Function Stream Input
• 7-111 k1e Function Relation Output
• 7-112 kn Function Query
• 7-113 kn Function Stream Input
• 7-114 kn Function Relation Output
• 7-115 leastsignificantbit Function Query
• 7-116 leastsignificantbit Function Stream Input
• 7-117 leastsignificantbit Function Relation Output
• 7-118 log Function Query
• 7-119 log Function Stream Input
• 7-120 log Function Relation Output
• 7-121 log10 Function Query
• 7-122 log10 Function Stream Input
• 7-123 log10 Function Relation Output
• 7-124 log2 Function Query
• 7-125 log2 Function Stream Input
• 7-126 log2 Function Relation Output
• 7-127 logfactorial Function Query
• 7-128 logfactorial Function Stream Input
• 7-129 logfactorial Function Relation Output
• 7-130 loggamma Function Query
• 7-131 loggamma Function Stream Input
• 7-132 loggamma Function Relation Output
• 7-133 longfactorial Function Query
• 7-134 longfactorial Function Stream Input
• 7-135 longfactorial Function Relation Output
• 7-136 mostsignificantbit Function Query
• 7-137 mostsignificantbit Function Stream Input
• 7-138 mostsignificantbit Function Relation Output
• 7-139 negativebinomial Function Query
• 7-140 negativebinomial Function Stream Input
• 7-141 negativebinomial Function Relation Output
• 7-142 negativebinomialcomplemented Function Query
• 7-143 negativebinomialcomplemented Function Stream Input
• 7-144 negativebinomialcomplemented Function Relation Output
• 7-145 normal Function Query
• 7-146 normal Function Stream Input
• 7-147 normal Function Relation Output
• 7-148 normal1 Function Query
• 7-149 normal1 Function Stream Input
• 7-150 normal1 Function Relation Output
• 7-151 normalinverse Function Query
• 7-152 normalinverse Function Stream Input
• 7-153 normalinverse Function Relation Output
• 7-154 poisson Function Query
• 7-155 poisson Function Stream Input
• 7-156 poisson Function Relation Output
• 7-157 poissoncomplemented Function Query
• 7-158 poissoncomplemented Function Stream Input
• 7-159 poissoncomplemented Function Relation Output
• 7-160 stirlingcorrection Function Query
• 7-161 stirlingcorrection Function Stream Input
• 7-162 stirlingcorrection Function Relation Output
• 7-163 studentt Function Query
• 7-164 studentt Function Stream Input
• 7-165 studentt Function Relation Output
• 7-166 studenttinverse Function Query
• 7-167 studenttinverse Function Stream Input
• 7-168 studenttinverse Function Relation Output
• 7-169 y0 Function Query
• 7-170 y0 Function Stream Input
• 7-171 y0 Function Relation Output
• 7-172 y1 Function Query
• 7-173 y1 Function Stream Input
• 7-174 y1 Function Relation Output
• 7-175 yn Function Query
• 7-176 yn Function Stream Input
• 7-177 yn Function Relation Output
• 8-1 autocorrelation Function Query
• 8-2 autocorrelation Function Stream Input
• 8-3 autocorrelation Function Relation Output
• 8-4 correlation Function Query
• 8-5 correlation Function Stream Input
• 8-6 correlation Function Relation Output
• 8-7 covariance Function Query
• 8-8 covariance Function Stream Input
• 8-9 covariance Function Relation Output
• 8-10 geometricmean Function Query
• 8-11 geometricmean Function Stream Input
• 8-12 geometricmean Function Relation Output
• 8-13 geometricmean1 Function Query
• 8-14 geometricmean1 Function Stream Input
• 8-15 geometricmean1 Function Relation Output
• 8-16 harmonicmean Function Query
• 8-17 harmonicmean Function Stream Input
• 8-18 harmonicmean Function Relation Output
• 8-19 kurtosis Function Query
• 8-20 kurtosis Function Stream Input
• 8-21 kurtosis Function Relation Output
• 8-22 lag1 Function Query
• 8-23 lag1 Function Stream Input
• 8-24 lag1 Function Relation Output
• 8-25 mean Function Query
• 8-26 mean Function Stream Input
• 8-27 mean Function Relation Output
• 8-28 meandeviation Function Query
• 8-29 meandeviation Function Stream Input
• 8-30 meandeviation Function Relation Output
• 8-31 median Function Query
• 8-32 median Function Stream Input
• 8-33 median Function Relation Output
• 8-34 moment Function Query
• 8-35 moment Function Stream Input
• 8-36 moment Function Relation Output
• 8-37 pooledmean Function Query
• 8-38 pooledmean Function Stream Input
• 8-39 pooledmean Function Relation Output
• 8-40 pooledvariance Function Query
• 8-41 pooledvariance Function Stream Input
• 8-42 pooledvariance Function Relation Output
• 8-43 product Function Query
• 8-44 product Function Stream Input
• 8-45 product Function Relation Output
• 8-46 quantile Function Query
• 8-47 quantile Function Stream Input
• 8-48 quantile Function Relation Output
• 8-49 quantileinverse Function Query
• 8-50 quantileinverse Function Stream Input
• 8-51 quantileinverse Function Relation Output
• 8-52 rankinterpolated Function Query
• 8-53 rankinterpolated Function Stream Input
• 8-54 rankinterpolated Function Relation Output
• 8-55 rms Function Query
• 8-56 rms Function Stream Input
• 8-57 rms Function Relation Output
• 8-58 samplekurtosis Function Query
• 8-59 samplekurtosis Function Stream Input
• 8-60 samplekurtosis Function Relation Output
• 8-61 samplekurtosisstandarderror Function Query
• 8-62 samplekurtosisstandarderror Function Stream Input
• 8-63 samplekurtosisstandarderror Function Relation Output
• 8-64 sampleskew Function Query
• 8-65 sampleskew Function Stream Input
• 8-66 sampleskew Function Relation Output
• 8-67 sampleskewstandarderror Function Query
• 8-68 sampleskewstandarderror Function Stream Input
• 8-69 sampleskewstandarderror Function Relation Output
• 8-70 samplevariance Function Query
• 8-71 samplevariance Function Stream Input
• 8-72 samplevariance Function Relation Output
• 8-73 skew Function Query
• 8-74 skew Function Stream Input
• 8-75 skew Function Relation Output
• 8-76 standarddeviation Function Query
• 8-77 standarddeviation Function Stream Input
• 8-78 standarddeviation Function Relation Output
• 8-79 standarderror Function Query
• 8-80 standarderror Function Stream Input
• 8-81 standarderror Function Relation Output
• 8-82 sumofinversions Function Query
• 8-83 sumofinversions Function Stream Input
• 8-84 sumofinversions Function Relation Output
• 8-85 sumoflogarithms Function Query
• 8-86 sumoflogarithms Function Stream Input
• 8-87 sumoflogarithms Function Relation Output
• 8-88 sumofpowerdeviations Function Query
• 8-89 sumofpowerdeviations Function Stream Input
• 8-90 sumofpowerdeviations Function Relation Output
• 8-91 sumofpowers Function Query
• 8-92 sumofpowers Function Stream Input
• 8-93 sumofpowers Function Relation Output
• 8-94 sumofsquareddeviations Function Query
• 8-95 sumofsquareddeviations Function Stream Input
• 8-96 sumofsquareddeviations Function Relation Output
• 8-97 sumofsquares Function Query
• 8-98 sumofsquares Function Stream Input
• 8-99 sumofsquares Function Relation Output
• 8-100 trimmedmean Function Query
• 8-101 trimmedmean Function Stream Input
• 8-102 trimmedmean Function Relation Output
• 8-103 variance Function Query
• 8-104 variance Function Stream Input
• 8-105 variance Function Relation Output
• 8-106 weightedmean Function Query
• 8-107 weightedmean Function Stream Input
• 8-108 weightedmean Function Relation Output
• 8-109 winsorizedmean Function Query
• 8-110 winsorizedmean Function Stream Input
• 8-111 winsorizedmean Function Relation Output
• 9-1 abs Function Query
• 9-2 abs Function Stream Input
• 9-3 abs Function Stream Output
• 9-4 abs1 Function Query
• 9-5 abs1 Function Stream Input
• 9-6 abs1 Function Stream Output
• 9-7 abs2 Function Query
• 9-8 abs2 Function Stream Input
• 9-9 abs2 Function Stream Output
• 9-10 abs3 Function Query
• 9-11 abs3 Function Stream Input
• 9-12 abs3 Function Stream Output
• 9-13 acos Function Query
• 9-14 acos Function Stream Input
• 9-15 acos Function Stream Output
• 9-16 asin Function Query
• 9-17 asin Function Stream Input
• 9-18 asin Function Stream Output
• 9-19 atan Function Query
• 9-20 atan Function Stream Input
• 9-21 atan Function Stream Output
• 9-22 atan2 Function Query
• 9-23 atan2 Function Stream Input
• 9-24 atan2 Function Stream Output
• 9-25 cbrt Function Query
• 9-26 cbrt Function Stream Input
• 9-27 cbrt Function Stream Output
• 9-28 ceil1 Function Query
• 9-29 ceil1 Function Stream Input
• 9-30 ceil1 Function Stream Output
• 9-31 cos Function Query
• 9-32 cos Function Stream Input
• 9-33 cos Function Stream Output
• 9-34 cosh Function Query
• 9-35 cosh Function Stream Input
• 9-36 cosh Function Stream Output
• 9-37 exp Function Query
• 9-38 exp Function Stream Input
• 9-39 exp Function Stream Output
• 9-40 expm1 Function Query
• 9-41 expm1 Function Stream Input
• 9-42 expm1 Function Stream Output
• 9-43 floor1 Function Query
• 9-44 floor1 Function Stream Input
• 9-45 floor1 Function Stream Output
• 9-46 hypot Function Query
• 9-47 hypot Function Stream Input
• 9-48 hypot Function Stream Output
• 9-49 ieeeremainder Function Query
• 9-50 ieeeremainder Function Stream Input
• 9-51 ieeeremainder Function Stream Output
• 9-52 log1 Function Query
• 9-53 log1 Function Stream Input
• 9-54 log1 Function Stream Output
• 9-55 log101 Function Query
• 9-56 log101 Function Stream Input
• 9-57 log101 Function Stream Output
• 9-58 log1p Function Query
• 9-59 log1p Function Stream Input
• 9-60 log1p Function Stream Output
• 9-61 pow Function Query
• 9-62 pow Function Stream Input
• 9-63 pow Function Stream Output
• 9-64 rint Function Query
• 9-65 rint Function Stream Input
• 9-66 rint Function Stream Output
• 9-67 round Function Query
• 9-68 round Function Stream Input
• 9-69 round Function Stream Output
• 9-70 round1 Function Query
• 9-71 round1 Function Stream Input
• 9-72 round1 Function Stream Output
• 9-73 signum Function Query
• 9-74 signum Function Stream Input
• 9-75 signum Function Stream Output
• 9-76 signum1 Function Query
• 9-77 signum1 Function Stream Input
• 9-78 signum1 Function Relation Output
• 9-79 sin Function Query
• 9-80 sin Function Stream Input
• 9-81 sin Function Stream Output
• 9-82 sinh Function Query
• 9-83 sinh Function Stream Input
• 9-84 sinh Function Stream Output
• 9-85 sqrt Function Query
• 9-86 sqrt Function Stream Input
• 9-87 sqrt Function Stream Output
• 9-88 tan Function Query
• 9-89 tan Function Stream Input
• 9-90 tan Function Stream Output
• 9-91 tanh Function Query
• 9-92 tanh Function Stream Input
• 9-93 tanh Function Stream Output
• 9-94 todegrees Function Query
• 9-95 todegrees Function Stream Input
• 9-96 todegrees Function Stream Output
• 9-97 toradians Function Query
• 9-98 toradians Function Stream Input
• 9-99 toradians Function Stream Output
• 9-100 ulp Function Query
• 9-101 ulp Function Stream Input
• 9-102 ulp Function Stream Output
• 9-103 ulp1 Function Query
• 9-104 ulp1 Function Stream Input
• 9-105 ulp1 Function Relation Output
• 10-1 MyMod.java User-Defined Single-Row Function
• 10-2 Single-Row User Defined Function for an Oracle CQL Processor
• 10-3 Accessing a User-Defined Single-Row Function in Oracle CQL
• 10-4 Variance.java User-Defined Aggregate Function
• 10-5 Aggregate User Defined Function for an Oracle CQL Processor
• 10-6 Accessing a User-Defined Aggregate Function in Oracle CQL
• 11-1 aggr_distinct_expr for COUNT
• 11-2 aggr_expr for COUNT
• 11-3 arith_expr
• 11-4 arith_expr_list
• 11-5 CASE Expression: SELECT * Query
• 11-6 CASE Expression: SELECT * Stream Input
• 11-7 CASE Expression: SELECT * Relation Output
• 11-8 CASE Expression: SELECT Query
• 11-9 CASE Expression: SELECT Stream S0 Input
• 11-10 CASE Expression: SELECT Stream S1 Input
• 11-11 CASE Expression: SELECT Relation Output
• 11-12 Arithmetic Expression and DECODE Query
• 11-13 Arithmetic Expression and DECODE Relation Input
• 11-14 Arithmetic Expression and DECODE Relation Output
• 11-15 func_expr for PREV
• 11-16 func_expr for XMLQUERY
• 11-17 func_expr for SUM
• 11-18 order_expr
• 11-19 xml_agg_expr Query
• 11-20 xml_agg_expr Relation Input
• 11-21 xml_agg_expr Relation Output
• 11-22 xmlcolattval_expr Query
• 11-23 xmlcolattval_expr Relation Input
• 11-24 xmlcolattval_expr Relation Output
• 11-25 xmlelement_expr Query
• 11-26 xmlelement_expr Relation Input
• 11-27 xmlelement_expr Relation Output
• 11-28 xmlforest_expr Query
• 11-29 xmlforest_expr Relation Input
• 11-30 xmlforest_expr Relation Output
• 11-31 xml_parse_expr Content: Query
• 11-32 xml_parse_expr Content: Relation Input
• 11-33 xml_parse_expr Content: Relation Output
• 11-34 xml_parse_expr Document: Query
• 11-35 xml_parse_expr Document: Relation Input
• 11-36 xml_parse_expr Document: Relation Output
• 11-37 xml_parse_expr Wellformed: Query
• 11-38 xml_parse_expr Wellformed: Relation Input
• 11-39 xml_parse_expr Wellformed: Relation Output
• 13-1 attr Clause
• 13-2 xml_attr_list
• 14-1 Typical Oracle CQL Query
• 14-2 Fully Qualified Stream Element Names
• 14-3 Simple Query
• 14-4 Built-In Window Query
• 14-5 MATCH_RECOGNIZE Query
• 14-6 XMLTABLE Query
• 14-7 Using Views Instead of Subqueries
• 14-8 Using View Names to Distinguish Between Stream Elements of the Same Name
• 14-9 Fully Qualified Stream Element Names
• 14-10 Inner Joins
• 14-11 Outer Joins
• 14-12 Left Outer Joins
• 14-13 Right Outer Joins
• 14-14 Outer Join Look-Back
• 15-1 Pattern Matching Conditions
• 15-2 ALL MATCHES Clause Query
• 15-3 ALL MATCHES Clause Stream Input
• 15-4 ALL MATCHES Clause Stream Output
• 15-5 Undefined Correlation Name
• 15-6 MATCH_RECOGNIZE with Fixed Duration DURATION Clause Query
• 15-7 MATCH_RECOGNIZE with Fixed Duration DURATION Clause Stream Input
• 15-8 MATCH_RECOGNIZE with Fixed DURATION Clause Stream Output
• 15-9 MATCH_RECOGNIZE with Variable Duration DURATION MULTIPLES OF Clause Query
• 15-10 MATCH_RECOGNIZE with Variable Duration DURATION MULTIPLES OF Clause Stream Input
• 15-11 MATCH_RECOGNIZE with Variable Duration DURATION MULTIPLES OF Clause Stream Output
• 15-12 Input Stream S1
• 15-13 MATCH_RECOGNIZE Query Using Input Stream S1
• 15-14 MATCH_RECOGNIZE with SUBSET Clause Query
• 15-15 MATCH_RECOGNIZE with SUBSET Clause Stream Input
• 15-16 MATCH_RECOGNIZE with SUBSET Clause Stream Output
• 15-17 Simple Pattern Detection: Query
• 15-18 Pattern Detection With Partition By: Query
• 15-19 Pattern Detection With Aggregates: Query
• 15-20 Pattern Detection With Aggregates: Stream Input
• 15-21 Pattern Detection With Aggregates: Stream Output
• 15-22 Fixed Duration Non-Event Detection: Query
• 16-1 Query in a <query></query> Element
• 16-2 REGISTER QUERY
• 16-3 HAVING Query
• 16-4 HAVING Stream Input
• 16-5 HAVING Relation Output
• 16-6 Set Operators: UNION Query
• 16-7 Set Operators: UNION Relation Input R1
• 16-8 Set Operators: UNION Relation Input R2
• 16-9 Set Operators: UNION Relation Output
• 16-10 Set Operators: UNION ALL Relation Output
• 16-11 Set Operators: INTERSECT Query
• 16-12 Set Operators: INTERSECT Relation Input R1
• 16-13 Set Operators: INTERSECT Relation Input R2
• 16-14 Set Operators: INTERSECT Relation Output
• 16-15 Set Operators: MINUS Query
• 16-16 Set Operators: MINUS Relation Input R1
• 16-17 Set Operators: MINUS Relation Input R2
• 16-18 Set Operators: MINUS Relation Output
• 16-19 Select DISTINCT Query
• 16-20 Select DISTINCT Stream Input
• 16-21 Select DISTINCT Stream Output
• 16-22 XMLTABLE Query
• 16-23 XMLTABLE Stream Input
• 16-24 XMLTABLE Relation Output
• 16-25 XMLTABLE With XML Namespaces Query
• 16-26 XMLTABLE With XML Namespaces Stream Input
• 16-27 XMLTABLE With XML Namespaces Relation Output
• 16-28 ORDER BY ROWS Query
• 16-29 ORDER BY ROWS Stream Input
• 16-30 ORDER BY ROWS Output
• 16-31 View in a <view></view> Element
• 16-32 REGISTER VIEW