Oracle Built-in Functions
Version 11.1
Function Name
Analytic
Collection
Conver
sion
Date
Time
Data Mining
Misc.
Model
Clause
Null
Handling
Numeric
Object
String
XML
ABS
ACOS
ADD_MONTHS
ADJ_DATE
APPENDCHILDXML
ASCII
ASCIISTR
ASIN
ATAN
ATAN2
AVG
BFILENAME
BIN_TO_NUM
BINARY2VARCHAR
BIT_COMPLEMENT
BIT_OR
BIT_XOR
BITAND
BOOL_TO_INT
CARDINALITY
CASE
CAST
CAST_FROM_BINARY
_DOUBLE
CAST_FROM_BINARY
_FLOAT
CAST_FROM_BINARY
_INTEGER
CAST_FROM_NUMBER
CAST_TO_BINARY
_DOUBLE
CAST_TO_BINARY_FLOAT
CAST_TO_BINARY
_INTEGER
CAST_TO_NUMBER
CAST_TO_NVARCHAR2
CAST_TO_RAW
CAST_TO_VARCHAR
CEIL
CHARTOROWID
CHR
CLUSTER_ID
CLUSTER_PROBABILITY
CLUSTER_SET
COALESCE
COLLECT
COMPOSE
CONCAT
CONVERT
CORR
CORR_K
CORR_S
COS
COSH
COUNT
COVAR_POP
COVAR_SAMP
CUME_DIST
CURRENT_DATE
CURRENT_TIMESTAMP
CV
DBTIMEZONE
DENSE_RANK
DECODE
DECOMPOSE
DELETEXML
DEPTH
DEREF
DUMP
EMPTY_BLOB (large object)
EMPTY_CLOB (large object)
ESTIMATE_CPU_UNITS
EXISTSNODE
EXP
EXTRACT
EXTRACTVALUE
FEATURE_ID
FEATURE_SET
FEATURE_VALUE
FIRST
FIRST_VALUE
FLOOR
FROM_TZ
GET_CLOCK_TIME
GET_DDL
GET_DEPENDENT_DDL
GET_DEPENDENT_XML
GET_GRANTED_DDL
GET_GRANTED_XDL
GET_HASH
GET_REBUILD_COMMAND
GET_SCN
GET_XML
GREATEST
GROUP_ID
GROUPING
GROUPING_ID
HEXTORAW
INITCAP
INSERTCHILDXML
INSERTXMLBEFORE
INSTR
INSTRB
INSTRC
INSTR2
INSTR4
INT_TO_BOOL
INTERVAL
ITERATE
ITERATE UNTIL
ITERATION_NUMBER
LAG
LAST
LAST_DAY
LAST_VALUE
LEAD
LEAST