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 DURBINWATSON Function Query
• 8-11 DURBINWATSON Function Stream Input
• 8-12 DURBINWATSON Function Relation Output
• 8-13 GEOMETRICMEAN Function Query
• 8-14 GEOMETRICMEAN Function Stream Input
• 8-15 GEOMETRICMEAN Function Relation Output
• 8-16 GEOMETRICMEAN1 Function Query
• 8-17 GEOMETRICMEAN1 Function Stream Input
• 8-18 GEOMETRICMEAN1 Function Relation Output
• 8-19 HARMONICMEAN Function Query
• 8-20 HARMONICMEAN Function Stream Input
• 8-21 HARMONICMEAN Function Relation Output
• 8-22 KURTOSIS Function Query
• 8-23 KURTOSIS Function Stream Input
• 8-24 KURTOSIS Function Relation Output
• 8-25 LAG1 Function Query
• 8-26 LAG1 Function Stream Input
• 8-27 LAG1 Function Relation Output
• 8-28 MEAN Function Query
• 8-29 MEAN Function Stream Input
• 8-30 MEAN Function Relation Output
• 8-31 MEANDEVIATION Function Query
• 8-32 MEANDEVIATION Function Stream Input
• 8-33 MEANDEVIATION Function Relation Output
• 8-34 MEDIAN Function Query
• 8-35 MEDIAN Function Stream Input
• 8-36 MEDIAN Function Relation Output
• 8-37 MOMENT Function Query
• 8-38 MOMENT Function Stream Input
• 8-39 MOMENT Function Relation Output
• 8-40 POOLEDMEAN Function Query
• 8-41 POOLEDMEAN Function Stream Input
• 8-42 POOLEDMEAN Function Relation Output
• 8-43 POOLEDVARIANCE Function Query
• 8-44 POOLEDVARIANCE Function Stream Input
• 8-45 POOLEDVARIANCE Function Relation Output
• 8-46 PRODUCT Function Query
• 8-47 PRODUCT Function Stream Input
• 8-48 PRODUCT Function Relation Output
• 8-49 QUANTILE Function Query
• 8-50 QUANTILE Function Stream Input
• 8-51 QUANTILE Function Relation Output
• 8-52 QUANTILEINVERSE Function Query
• 8-53 QUANTILEINVERSE Function Stream Input
• 8-54 QUANTILEINVERSE Function Relation Output
• 8-55 RANKINTERPOLATED Function Query
• 8-56 RANKINTERPOLATED Function Stream Input
• 8-57 RANKINTERPOLATED Function Relation Output
• 8-58 RMS Function Query
• 8-59 RMS Function Stream Input
• 8-60 RMS Function Relation Output
• 8-61 SAMPLEKURTOSIS Function Query
• 8-62 SAMPLEKURTOSIS Function Stream Input
• 8-63 SAMPLEKURTOSIS Function Relation Output
• 8-64 SAMPLEKURTOSISSTANDARDERROR Function Query
• 8-65 SAMPLEKURTOSISSTANDARDERROR Function Stream Input
• 8-66 SAMPLEKURTOSISSTANDARDERROR Function Relation Output
• 8-67 SAMPLESKEW Function Query
• 8-68 SAMPLESKEW Function Stream Input
• 8-69 SAMPLESKEW Function Relation Output
• 8-70 SAMPLESKEWSTANDARDERROR Function Query
• 8-71 SAMPLESKEWSTANDARDERROR Function Stream Input
• 8-72 SAMPLESKEWSTANDARDERROR Function Relation Output
• 8-73 SAMPLESTANDARDDEVIATION Function Query
• 8-74 SAMPLESTANDARDDEVIATION Function Stream Input
• 8-75 SAMPLESTANDARDDEVIATION Function Relation Output
• 8-76 SAMPLEVARIANCE Function Query
• 8-77 SAMPLEVARIANCE Function Stream Input
• 8-78 SAMPLEVARIANCE Function Relation Output
• 8-79 SKEW Function Query
• 8-80 SKEW Function Stream Input
• 8-81 SKEW Function Relation Output
• 8-82 STANDARDDEVIATION Function Query
• 8-83 STANDARDDEVIATION Function Stream Input
• 8-84 STANDARDDEVIATION Function Relation Output
• 8-85 STANDARDERROR Function Query
• 8-86 STANDARDERROR Function Stream Input
• 8-87 STANDARDERROR Function Relation Output
• 8-88 SUMOFINVERSIONS Function Query
• 8-89 SUMOFINVERSIONS Function Stream Input
• 8-90 SUMOFINVERSIONS Function Relation Output
• 8-91 SUMOFLOGARITHMS Function Query
• 8-92 SUMOFLOGARITHMS Function Stream Input
• 8-93 SUMOFLOGARITHMS Function Relation Output
• 8-94 SUMOFPOWERDEVIATIONS Function Query
• 8-95 SUMOFPOWERDEVIATIONS Function Stream Input
• 8-96 SUMOFPOWERDEVIATIONS Function Relation Output
• 8-97 SUMOFPOWERS Function Query
• 8-98 SUMOFPOWERS Function Stream Input
• 8-99 SUMOFPOWERS Function Relation Output
• 8-100 SUMOFSQUAREDDEVIATIONS Function Query
• 8-101 SUMOFSQUAREDDEVIATIONS Function Stream Input
• 8-102 SUMOFSQUAREDDEVIATIONS Function Relation Output
• 8-103 SUMOFSQUARES Function Query
• 8-104 SUMOFSQUARES Function Stream Input
• 8-105 SUMOFSQUARES Function Relation Output
• 8-106 TRIMMEDMEAN Function Query
• 8-107 TRIMMEDMEAN Function Stream Input
• 8-108 TRIMMEDMEAN Function Relation Output
• 8-109 VARIANCE Function Query
• 8-110 VARIANCE Function Stream Input
• 8-111 VARIANCE Function Relation Output
• 8-112 WEIGHTEDMEAN Function Query
• 8-113 WEIGHTEDMEAN Function Stream Input
• 8-114 WEIGHTEDMEAN Function Relation Output
• 8-115 RMS Function Query
• 8-116 RMS Function Stream Input
• 8-117 RMS 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
• 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 DURATION Clause Query
• 15-7 MATCH_RECOGNIZE with DURATION Clause Stream Input
• 15-8 MATCH_RECOGNIZE with DURATION Clause Stream Output
• 15-9 MATCH_RECOGNIZE with DURATION MULTIPLES OF Clause Query
• 15-10 MATCH_RECOGNIZE with DURATION MULTIPLES OF Clause Stream Input
• 15-11 MATCH_RECOGNIZE with 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 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 ORDER BY ROWS Query
• 16-26 ORDER BY ROWS Stream Input
• 16-27 ORDER BY ROWS Output
• 16-28 View in a <view></view> Element
• 16-29 REGISTER VIEW