Skip Headers
Oracle® OLAP DML Reference
11g Release 1 (11.1)

B28126-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
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

Functions by Category

The OLAP DML provides the typical numeric and text functions:

Conversion functions
Datetime functions
Date-only functions
Financial functions
File management functions
NA functions
Numeric (general) functions
Numeric aggregation functions
Program argument and context functions
Reporting functions
Statistical and forecasting functions
Text functions

It also has functions that are unique to its data model:

Analytic workspace and object information function
Aggregation, allocation, and model specification functions
System and Database information functions
Time-series functions
Object value retrieval functions
Status manipulation functions

Analytic workspace and object information function


AW function
CHANGEDRELATIONS
CHANGEDVALUES
BASEDIM
EXISTS
ISEMPTY
ISSESSION
ISVALUE
LIMITMAPINFO
OBJ
OBJLIST
PARTITION
RESERVED
TALLY
TRIGGER function
VALSPERPAGE
WRITABLE

Aggregation, allocation, and model specification functions


AGGCOUNT
AGGMAPINFO
AGGREGATE function
AGGREGATION
AGGROPS
ALLOCOPS
HIERCHECK
INFO
CHANGEDRELATIONS
CHANGEDVALUES
ISEMPTY
PARTITIONCHECK

Conversion functions


BIN_TO_NUM
CHR
CONVERT
FROM_TZ
TCONVERT
TO_CHAR
TO_DATE
TO_NCHAR
TO_NUMBER
TO_TIMESTAMP
TO_TIMESTAMP_TZ

System and Database information functions


CURRENT_DATE
CURRENT_TIMESTAMP
DBTIMEZONE
LOCALTIMESTAMP
SESSIONTIMEZONE
SYS_CONTEXT
SYSDATE
SYSINFO
SYSTEM

Datetime functions


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

Date-only functions


BEGINDATE
DAYOF
DDOF
ENDDATE
ENDOF
ISDATE
MAKEDATE
MMOF
STARTOF
TODAY
WEEKOF
YYOF

Financial functions


DEPRDECL
DEPRDECLSW
DEPRSL
DEPRSOYD
FINTSCHED
FPMTSCHED
GROWRATE
IRR
NPV
VINTSCHED
VPMTSCHED

File management functions


FILEERROR
FILEGET
FILENEXT
FILEOPEN
FILEQUERY
GET
RECNO

NA functions


COALESCE
NA2
NAFILL
NAFLAG
NULLIF
NVL
NVL2

Numeric (general) functions


ABS
ANTILOG
ANTILOG10
ARCCOS
ARCSIN
ARCTAN
ARCTAN2
BIN_TO_NUM
BITAND
CEIL
COS
COSH
DECODE
EXP
FLOOR
GREATEST
INTPART
LEAST
LOG function
LOG10
MAX
MIN
MODULO
NULLIF
RANK
REM
REMAINDER
ROUND (number)
SIGN
SIN
SINH
SMOOTH
SORT function
SQRT
TAN
TANH
TRUNCATE (number)
WIDTH_BUCKET

Numeric aggregation functions


ANY
AVERAGE
COUNT
EVERY
LARGEST
MEDIAN
MODE
NONE
PERCENTAGE
SMALLEST
TCONVERT
TOTAL

Object value retrieval functions


BASEVAL
CHGDIMS
COALESCE
HIERHEIGHT function
KEY
QUAL
ROW function
SORT function
UNRAVEL
VALUES
WKSDATA

Program argument and context functions


ARG
ARGCOUNT
ARGFR
ARGS
BACK
CALLTYPE
CONTEXT function

Reporting functions


COLVAL
RUNTOTAL
SUBTOTAL

Statistical and forecasting functions


CATEGORIZE
CORRELATION
FCOPEN
FCQUERY
INFO
NORMAL
RANDOM
STDDEV

Status manipulation functions


CHGDIMS
INSTAT
LIMIT function
STATALL
STATDEPTH
STATEQUAL
STATFIRST
STATLAST
STATLEN
STATLIST
STATMAX
STATMIN
STATRANK
STATVAL
VALUES

Text functions


ASCII
BLANKSTRIP
CHANGEBYTES
CHANGECHARS
CHARLIST
EXTBYTES
EXTCHARS
EXTCOLS
EXTLINES
FILTERLINES
FINDBYTES
FINDCHARS
FINDLINES
INITCAP
INLIST
INSBYTES
INSCHARS
INSCOLS
INSLINES
INSTR functions
JOINBYTES
JOINCHARS
JOINCOLS
JOINLINES
LEAST
LENGTH functions
LOWCASE
LPAD
LTRIM
MAXBYTES
MAXCHARS
NLSSORT
NULLIF
NUMBYTES
NUMCHARS
NUMLINES
OBSCURE
REMBYTES
REMCHARS
REMCOLS
REMLINES
REPLBYTES
REPLCHARS
REPLCOLS
REPLLINES
RPAD
RTRIM
SORT function
SORTLINES
SUBSTR functions
TEXTFILL
TRANSLATE
TRIM
UNIQUELINES
UPCASE

Time-series functions


CUMSUM
LAG
LAGABSPCT
LAGDIF
LAGPCT
LEAD
MOVINGAVERAGE
MOVINGMAX
MOVINGMIN
MOVINGTOTAL