Table of Contents
- List of Tables
- Title and Copyright Information
- Preface
-
1
Basic Elements
- Dimensional Object Names
- Dimensional Data Types
- Operators
- Conditions
- Literal Expressions
- CASE Expressions
- Qualified Data References (QDRs)
-
2
OLAP Functions
- OLAP Functions in Alphabetical Order
- OLAP Functions By Category
- AVERAGE_RANK
- AVG
- COUNT
- DENSE_RANK
- HIER_ANCESTOR
- HIER_CHILD_COUNT
- HIER_DEPTH
- HIER_LEVEL
- HIER_ORDER
- HIER_PARENT
- HIER_TOP
- LAG
- LAG_VARIANCE
- LAG_VARIANCE_PERCENT
- LEAD
- LEAD_VARIANCE
- LEAD_VARIANCE_PERCENT
- MAX
- MIN
- OLAP_DML_EXPRESSION
- RANK
- ROW_NUMBER
- SHARE
- SUM
-
3
Row Functions
- Row Functions in Alphabetical Order
- Row Functions By Category
- ABS
- ACOS
- ADD_MONTHS
- ASCII
- ASCIISTR
- ASIN
- ATAN
- ATAN2
- BIN_TO_NUM
- BITAND
- CAST
- CEIL
- CHARTOROWID
- CHR
- COALESCE
- CONCAT
- COS
- COSH
- CURRENT_DATE
- CURRENT_TIMESTAMP
- DBTIMEZONE
- DECODE
- EXP
- EXTRACT (datetime)
- FLOOR
- FROM_TZ
- GREATEST
- HEXTORAW
- INITCAP
- INSTR
- LAST_DAY
- LEAST
- LENGTH
- LN
- LNNVL
- LOCALTIMESTAMP
- LOG
- LOWER
- LPAD
- LTRIM
- MOD
- MONTHS_BETWEEN
- NANVL
- NEW_TIME
- NEXT_DAY
- NLS_CHARSET_ID
- NLS_CHARSET_NAME
- NLS_INITCAP
- NLS_LOWER
- NLS_UPPER
- NLSSORT
- NULLIF
- NUMTODSINTERVAL
- NUMTOYMINTERVAL
- NVL
- NVL2
- ORA_HASH
- POWER
- RAWTOHEX
- REGEXP_COUNT
- REGEXP_REPLACE
- REGEXP_INSTR
- REGEXP_SUBSTR
- REMAINDER
- REPLACE
- ROUND (date)
- ROUND (number)
- ROWIDTOCHAR
- ROWIDTONCHAR
- RPAD
- RTRIM
- SESSIONTIMEZONE
- SIGN
- SIN
- SINH
- SOUNDEX
- SQRT
- SUBSTR
- SYS_CONTEXT
- SYSDATE
- SYSTIMESTAMP
- TAN
- TANH
- TO_BINARY_DOUBLE
- TO_BINARY_FLOAT
- TO_CHAR (character)
- TO_CHAR (datetime)
- TO_CHAR (number)
- TO_DATE
- TO_DSINTERVAL
- TO_NCHAR (character)
- TO_NCHAR (datetime)
- TO_NCHAR (number)
- TO_NUMBER
- TO_TIMESTAMP
- TO_TIMESTAMP_TZ
- TO_YMINTERVAL
- TRANSLATE
- TRANSLATE (USING)
- TRIM
- TRUNC (number)
- TZ_OFFSET
- UID
- UNISTR
- UPPER
- USER
- VSIZE
- WIDTH_BUCKET
- A Reserved Words
- Index