Contents

Title and Copyright Information

Preface

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

1 Basic Elements

• Dimensional Object Names
  • Syntax
  • Examples
• Dimensional Data Types
• Operators
  • Unary Arithmetic Operators
    • Syntax
    • Example
  • Binary Arithmetic Operators
    • Syntax
    • Examples
  • Concatenation Operator
    • Syntax
    • Example
• Conditions
  • Simple Comparison Conditions
    • Syntax
    • Arguments
    • Examples
  • Group Comparison Conditions
    • Syntax
    • Examples
  • Range Conditions
    • Syntax
    • Example
  • Multiple Conditions
    • Syntax
    • Example
  • Negation Conditions
    • Syntax
    • Example
  • Special Conditions
    • Syntax
    • Example
  • Pattern-Matching Conditions
    • LIKE Operators
    • Syntax
    • Arguments
    • Examples
• Literal Expressions
  • Examples
• CASE Expressions
  • Return Value
  • Syntax
  • Arguments
  • Examples
• Qualified Data References (QDRs)
  • Syntax
  • Arguments
  • Examples

2 OLAP Functions

• OLAP Functions in Alphabetical Order
• OLAP Functions By Category
  • Aggregate Functions
  • Analytic Functions
  • Hierarchical Functions
  • Lag Functions
  • OLAP DML Functions
  • Rank Functions
  • Share Functions
  • Window Functions
• 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
  • Numeric Functions
  • Character Functions That Return Characters
  • NLS Character Functions
  • Character Functions That Return Numbers
  • Datetime Functions
  • General Comparison Functions
  • Conversion Functions
  • Encoding and Decoding Function
  • Null-Related Functions
  • Environment and Identifier Functions
• 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_INSTR
• REGEXP_REPLACE
• 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

• Reserved Words
• Special Symbols