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