Table 2-3 Built-ln Functions
Error |
Number |
Character |
Conversion |
Datę |
Obj Ref |
Misc |
SOLCODE |
ABS |
ASCII |
CHARTOROWIO |
ADD.MONTHS |
DEREF |
BFILENAME |
SOLERRM |
ACOS |
CHR |
CONVERT |
CURRENT_DATE |
REF |
DECODE |
ASIN |
CONCAT |
HEXTORAW |
CURRENT_TIMESTAMP |
VALUE |
DUMP | |
ATAN |
INITCAP |
RAWTOHEX |
DBTIMEZONE |
TREAT |
EMPTY BLOB | |
ATAN2 |
INSTR |
ROWIDTOCHAR |
EXTRACT |
EMPTY CLOB | ||
BITAND |
INSTRB |
TOJ3LOB |
FROM_TZ |
GREATEST | ||
CEIL |
LENGTH |
TO_CHAR |
LAST_DAY |
LEAST | ||
COS |
LENGTHB |
TO_CLOB |
LOCALTIMESTAMP |
NLS_CHARSET DECL LEN | ||
COSH |
LOWER |
TO.DATE |
MONTHS_BETWEEN |
NLS CHARSET ID | ||
EXP |
LPAD |
TO_MULTI_BYTE |
NEW„TIME |
N LS_CH ARS ET_N AM E | ||
FLOOR |
LTRIM |
TO_NCLOB |
NEXT_DAY |
NVL | ||
LN |
NLSJNITCAP |
TO_NUMBER |
NUMTODSINTERVAL |
SYS_CONTEXT | ||
LOG |
NLS_LOWER |
TO_SINGLE_BYTE |
NUMTOYMINTERVAL |
SYS GUID | ||
MOD |
NLSSORT |
ROUND |
UID | |||
POWER |
NLSJJPPER |
SESSIONTIMEZONE |
USER | |||
ROUND |
REPLACE |
SYSDATE |
USERENV | |||
SIGN |
RPAD |
SYSTIMESTAMP |
VSIZE | |||
SIN |
RTRIM |
TO_DSINTERVAL | ||||
SINH |
SOUNDEX |
TO_TIMESTAMP | ||||
SORT |
SUBSTR |
TO_TIMESTAMP_LTZ | ||||
TAN |
SUBSTRB |
TO_TIMESTAMP„TZ | ||||
TANH |
TRANSLATE |
TO_YMINTERVAL | ||||
TRUNC |
TRIM |
TZ_OFFSET | ||||
UPPER |
TRUNC |