Skip Headers
Oracle® OLAP Expression Syntax Reference
Release 11.2

E23381-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

3 Row Functions

The OLAP row functions extend the syntax of the SQL row functions for use with dimensional objects. If you use the SQL row functions, then this syntax is familiar. You can use these functions on relational data when loading it into cubes and cube dimensions, and with the OLAP functions when creating calculated measures.

This chapter describes the row functions of the OLAP expression syntax. It contains these topics:

Row Functions in Alphabetical Order

A B C D E F G H I L M N O P R S T U V W

A


ABS
ACOS
ADD_MONTHS
ASCII
ASCIISTR
ASIN
ATAN
ATAN2

B


BIN_TO_NUM
BITAND

C


CAST
CEIL
CHARTOROWID
CHR
COALESCE
CONCAT
COS
COSH
CURRENT_DATE
CURRENT_TIMESTAMP

D


DBTIMEZONE
DECODE

E


EXP
EXTRACT (datetime)

F


FLOOR
FROM_TZ

G


GREATEST

H


HEXTORAW

I


INITCAP
INSTR

L


LAST_DAY
LEAST
LENGTH
LN
LNNVL
LOCALTIMESTAMP
LOG
LOWER
LPAD
LTRIM

M


MOD
MONTHS_BETWEEN

N


NANVL
NEW_TIME
NEXT_DAY
NLS_CHARSET_ID
NLS_CHARSET_NAME
NLS_INITCAP
NLS_LOWER
NLS_UPPER
NLSSORT
NULLIF
NUMTODSINTERVAL
NUMTOYMINTERVAL
NVL
NVL2

O


ORA_HASH

P


POWER

R


RAWTOHEX
REGEXP_COUNT
REGEXP_INSTR
REGEXP_REPLACE
REGEXP_SUBSTR
REMAINDER
REPLACE
ROUND (date)
ROUND (number)
ROWIDTOCHAR
ROWIDTONCHAR
RPAD
RTRIM

S


SESSIONTIMEZONE
SIGN
SIN
SINH
SOUNDEX
SQRT
SUBSTR
SYS_CONTEXT
SYSDATE
SYSTIMESTAMP

T


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

U


UID
UNISTR
UPPER
USER

V


VSIZE

W


WIDTH_BUCKET

Row Functions By Category

The row functions are grouped into the following categories:

Numeric Functions

These functions accept numeric input and return numeric values:


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

Character Functions That Return Characters

These functions accept character input and return character values:


CHR
CONCAT
INITCAP
LOWER
LPAD
LTRIM
NLS_CHARSET_NAME
NLS_INITCAP
NLS_LOWER
NLS_UPPER
NLSSORT
REGEXP_REPLACE
REGEXP_SUBSTR
REPLACE
RPAD
RTRIM
SOUNDEX
SUBSTR
TRANSLATE
TRIM
UPPER

NLS Character Functions

These functions return information about a character set:


NLS_CHARSET_ID
NLS_CHARSET_NAME

Character Functions That Return Numbers

These functions accept character input and return numeric values:


ASCII
INSTR
LENGTH
REGEXP_COUNT
REGEXP_INSTR

General Comparison Functions

These functions determine the greatest or least value in a set of values:


GREATEST
LEAST

Encoding and Decoding Function

These functions return a numeric value for each input value:


DECODE
ORA_HASH
VSIZE

Null-Related Functions

These functions facilitate null handling:


COALESCE
LNNVL
NANVL
NULLIF
NVL
NVL2

Environment and Identifier Functions

These functions provide information about the instance and the session:


SYS_CONTEXT
UID
USER