OLAP Expression Syntax: Row Functions

These row functions are available in the OLAP. The syntax and functionality are extensions of the equivalent SQL functions. The functions are listed under the following categories:

Numeric Functions

ABS
ACOS
ASIN
ATAN
ATAN2
BITAND
CEIL
COS
COSH
EXP
FLOOR
LN
LOG
MOD
POWER
REMAINDER
ROUND (number)
SIGN
SIN
SINH
SQRT
TAN
TANH
TRUNC (number)
WIDTH_BUCKET

Character Functions That Return Characters

CHR
CONCAT
INITCAP
LOWER
LPAD
LTRIM
NLSSORT
REGEXP_REPLACE
REGEXP_SUBSTR
REPLACE
RPAD
RTRIM
SUBSTR
TRANSLATE
TRIM
UPPER

Character Functions That Return Numbers

ASCII
INSTR
LENGTH
REGEXP_INSTR

Datetime Functions

ADD_MONTHS
CURRENT_DATE
CURRENT_TIMESTAMP
DBTIMEZONE
EXTRACT (datetime)
FROM_TZ
LAST_DAY
LOCALTIMESTAMP
MONTHS_BETWEEN
NEW_TIME
NEXT_DAY
NUMTODSINTERVAL
NUMTOYMINTERVAL
ROUND (date)
SESSIONTIMEZONE
SYSDATE
SYSTIMESTAMP
TO_CHAR (datetime)
TO_TIMESTAMP
TO_TIMESTAMP_TZ
TO_DSINTERVAL
TO_YMINTERVAL
TZ_OFFSET

General Comparison Functions

GREATEST
LEAST

Conversion Functions

BIN_TO_NUM
CHARTOROWID
NUMTODSINTERVAL
NUMTOYMINTERVAL
ROWIDTOCHAR
ROWIDTONCHAR
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_DSINTERVAL
TO_TIMESTAMP_TZ
TO_YMINTERVAL
TRANSLATE

Encoding and Decoding Function

DECODE

Null-Related Functions

COALESCE
LNNVL
NULLIF
NVL
NVL2

Copyright © 2003, 2007, Oracle. All rights reserved.