1/9

Contents

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions
• Backus-Naur Form Syntax

1 Basic Elements

• 1.1 Dimensional Object Names
  • 1.1.1 Syntax
  • 1.1.2 Examples
• 1.2 Dimensional Data Types
• 1.3 Operators
  • 1.3.1 Unary Arithmetic Operators
    • 1.3.1.1 Syntax
    • 1.3.1.2 Example
  • 1.3.2 Binary Arithmetic Operators
    • 1.3.2.1 Syntax
    • 1.3.2.2 Examples
  • 1.3.3 Concatenation Operator
    • 1.3.3.1 Syntax
    • 1.3.3.2 Example
• 1.4 Conditions
  • 1.4.1 Simple Comparison Conditions
    • 1.4.1.1 Syntax
    • 1.4.1.2 Arguments
    • 1.4.1.3 Examples
  • 1.4.2 Group Comparison Conditions
    • 1.4.2.1 Syntax
    • 1.4.2.2 Examples
  • 1.4.3 Hierarchical Relation Conditions
    • 1.4.3.1 Syntax
    • 1.4.3.2 Arguments
    • 1.4.3.3 Examples
  • 1.4.4 Range Conditions
    • 1.4.4.1 Syntax
    • 1.4.4.2 Example
  • 1.4.5 Multiple Conditions
    • 1.4.5.1 Syntax
    • 1.4.5.2 Example
  • 1.4.6 Negation Conditions
    • 1.4.6.1 Syntax
    • 1.4.6.2 Example
  • 1.4.7 Special Conditions
    • 1.4.7.1 Syntax
    • 1.4.7.2 Example
  • 1.4.8 Pattern-Matching Conditions
    • 1.4.8.1 LIKE Operators
    • 1.4.8.2 Syntax
    • 1.4.8.3 Arguments
    • 1.4.8.4 Examples
• 1.5 Literal Expressions
  • 1.5.1 Examples
• 1.6 CASE Expressions
  • 1.6.1 Return Value
  • 1.6.2 Syntax
  • 1.6.3 Arguments
  • 1.6.4 Examples
• 1.7 Qualified Data References (QDRs)
  • 1.7.1 Syntax
  • 1.7.2 Arguments
  • 1.7.3 Examples

2 OLAP Functions

• 2.1 OLAP Functions in Alphabetical Order
• 2.2 OLAP Functions By Category
  • 2.2.1 Aggregate Functions
  • 2.2.2 Analytic Functions
  • 2.2.3 Hierarchical Functions
  • 2.2.4 Lag Functions
  • 2.2.5 OLAP DML Functions
  • 2.2.6 Rank Functions
  • 2.2.7 Share Functions
  • 2.2.8 Window Functions
• 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

• A.1 Reserved Words
• A.2 Special Symbols

Index