Table of Contents
- List of Tables
- Title and Copyright Information
- Preface
-
1
Basic Elements
- 1.1 Dimensional Object Names
- 1.2 Dimensional Data Types
- 1.3 Operators
- 1.4 Conditions
- 1.5 Literal Expressions
- 1.6 CASE Expressions
- 1.7 Qualified Data References (QDRs)
-
2
OLAP Functions
- 2.1 OLAP Functions in Alphabetical Order
- 2.2 OLAP Functions By Category
- 2.3 AVERAGE_RANK
- 2.4 AVG
- 2.5 COUNT
- 2.6 DENSE_RANK
- 2.7 HIER_ANCESTOR
- 2.8 HIER_CHILD_COUNT
- 2.9 HIER_DEPTH
- 2.10 HIER_LEVEL
- 2.11 HIER_ORDER
- 2.12 HIER_PARENT
- 2.13 HIER_TOP
- 2.14 LAG
- 2.15 LAG_VARIANCE
- 2.16 LAG_VARIANCE_PERCENT
- 2.17 LEAD
- 2.18 LEAD_VARIANCE
- 2.19 LEAD_VARIANCE_PERCENT
- 2.20 MAX
- 2.21 MIN
- 2.22 OLAP_DML_EXPRESSION
- 2.23 RANK
- 2.24 ROW_NUMBER
- 2.25 SHARE
- 2.26 SUM
-
3
Row Functions
- 3.1 Row Functions in Alphabetical Order
-
3.2
Row Functions By Category
- 3.2.1 Numeric Functions
- 3.2.2 Character Functions That Return Characters
- 3.2.3 NLS Character Functions
- 3.2.4 Character Functions That Return Numbers
- 3.2.5 Datetime Functions
- 3.2.6 General Comparison Functions
- 3.2.7 Conversion Functions
- 3.2.8 Encoding and Decoding Function
- 3.2.9 Null-Related Functions
- 3.2.10 Environment and Identifier Functions
- 3.3 ABS
- 3.4 ACOS
- 3.5 ADD_MONTHS
- 3.6 ASCII
- 3.7 ASCIISTR
- 3.8 ASIN
- 3.9 ATAN
- 3.10 ATAN2
- 3.11 BIN_TO_NUM
- 3.12 BITAND
- 3.13 CAST
- 3.14 CEIL
- 3.15 CHARTOROWID
- 3.16 CHR
- 3.17 COALESCE
- 3.18 CONCAT
- 3.19 COS
- 3.20 COSH
- 3.21 CURRENT_DATE
- 3.22 CURRENT_TIMESTAMP
- 3.23 DBTIMEZONE
- 3.24 DECODE
- 3.25 EXP
- 3.26 EXTRACT (datetime)
- 3.27 FLOOR
- 3.28 FROM_TZ
- 3.29 GREATEST
- 3.30 HEXTORAW
- 3.31 INITCAP
- 3.32 INSTR
- 3.33 LAST_DAY
- 3.34 LEAST
- 3.35 LENGTH
- 3.36 LN
- 3.37 LNNVL
- 3.38 LOCALTIMESTAMP
- 3.39 LOG
- 3.40 LOWER
- 3.41 LPAD
- 3.42 LTRIM
- 3.43 MOD
- 3.44 MONTHS_BETWEEN
- 3.45 NANVL
- 3.46 NEW_TIME
- 3.47 NEXT_DAY
- 3.48 NLS_CHARSET_ID
- 3.49 NLS_CHARSET_NAME
- 3.50 NLS_INITCAP
- 3.51 NLS_LOWER
- 3.52 NLS_UPPER
- 3.53 NLSSORT
- 3.54 NULLIF
- 3.55 NUMTODSINTERVAL
- 3.56 NUMTOYMINTERVAL
- 3.57 NVL
- 3.58 NVL2
- 3.59 ORA_HASH
- 3.60 POWER
- 3.61 RAWTOHEX
- 3.62 REGEXP_COUNT
- 3.63 REGEXP_REPLACE
- 3.64 REGEXP_INSTR
- 3.65 REGEXP_SUBSTR
- 3.66 REMAINDER
- 3.67 REPLACE
- 3.68 ROUND (date)
- 3.69 ROUND (number)
- 3.70 ROWIDTOCHAR
- 3.71 ROWIDTONCHAR
- 3.72 RPAD
- 3.73 RTRIM
- 3.74 SESSIONTIMEZONE
- 3.75 SIGN
- 3.76 SIN
- 3.77 SINH
- 3.78 SOUNDEX
- 3.79 SQRT
- 3.80 SUBSTR
- 3.81 SYS_CONTEXT
- 3.82 SYSDATE
- 3.83 SYSTIMESTAMP
- 3.84 TAN
- 3.85 TANH
- 3.86 TO_BINARY_DOUBLE
- 3.87 TO_BINARY_FLOAT
- 3.88 TO_CHAR (character)
- 3.89 TO_CHAR (datetime)
- 3.90 TO_CHAR (number)
- 3.91 TO_DATE
- 3.92 TO_DSINTERVAL
- 3.93 TO_NCHAR (character)
- 3.94 TO_NCHAR (datetime)
- 3.95 TO_NCHAR (number)
- 3.96 TO_NUMBER
- 3.97 TO_TIMESTAMP
- 3.98 TO_TIMESTAMP_TZ
- 3.99 TO_YMINTERVAL
- 3.100 TRANSLATE
- 3.101 TRANSLATE (USING)
- 3.102 TRIM
- 3.103 TRUNC (number)
- 3.104 TZ_OFFSET
- 3.105 UID
- 3.106 UNISTR
- 3.107 UPPER
- 3.108 USER
- 3.109 VSIZE
- 3.110 WIDTH_BUCKET
- A Reserved Words
- Index