Index Index A B C D F G H I L M N O P Q R S T U V W A ancestor function 1 arguments 1 AVERAGE_RANK 1 average function 1 AVG 1 B BETWEEN operator 1 binary operators 1 C CASE expressions 1 character literal 1 child count function 1 comparison operators 1 concatenation operator 1 conditions 1 COUNT 1 counting functions 1, 2 cumulative averages 1 D data types 1 DENSE_RANK 1 depth function 1 difference from future period 1 difference from prior period 1, 2 DML expressions 1 F future period functions 1, 2, 3 G group comparison operators 1 H HIER_ANCESTOR 1 HIER_CHILD_COUNT 1 HIER_DEPTH 1 HIER_LEVEL 1 HIER_ORDER 1 HIER_PARENT 1 HIER_TOP 1 I identifiers 1 IF ... THEN ... ELSE 1 IS operator 1 L LAG 1 LAG_VARIANCE 1 LAG_VARIANCE_PERCENT 1 largest values 1 later period functions 1, 2, 3 LEAD 1 LEAD_VARIANCE 1 LEAD_VARIANCE_PERCENT 1 level depth function 1 level function 1 LIKE operators 1 literal expressions 1 M MAX 1 MIN 1 moving averages 1 N naming conventions 1 NOT operator 1 O object names 1 OLAP_DML_EXPRESSION 1 ordering function 1 P parent function 1 percent difference from future period 1 percent difference from prior period 1 period-to-date function 1 prior period functions 1, 2, 3 Q qualified data references 1 quotes double, for reserved words 1 in naming conventions 1 single, for text literals 1 R RANK 1 ranking functions 1, 2, 3, 4 ratios 1 ROW_NUMBER 1 S SHARE 1 smallest values 1 sorting functions 1, 2, 3, 4, 5 SPL expressions 1 string 1 SUM 1 T text literal 1 top function 1 U unary operators 1 V variance functions 1, 2, 3, 4 W WHEN ... THEN 1 windowing functions 1, 2, 3, 4, 5