List of function names and value specifications:
ABS
ACOS
ADDATE
ADDTIME
ALL
ALPHA
ASCII
ASIN
ATAN
ATAN2
AVG
CASE
CEIL
CHAR
CHR
COS
COSH
COT
COUNT
CURRENT_SCHEMA{*}
CURRVAL{*}
DATE
DATE{*}
DATEDIFF
DAY
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DECODE
DEFAULT{*}
DEGREES
DISTINCT
EXCEPT
EXP
EXPAND
FIXED
FLOAT
FLOOR
GET_OBJECTNAME
GET_SCHEMA
GREATEST
HEX
HEXTORAW
HOUR
INDEX
INITCAP
INTERSECT
INTTORAW
LEAST
LENGTH
LFILL
LIMIT
LN
LOG
LOWER
LPAD
LTRIM
MAKEDATE
MAKETIME
MAPCHAR
MAX
MICROSECOND
MIN
MINUTE
MONTH
MONTHNAME
NEXTVAL{*}
NOROUND
NULL{*}
NUM
PI
POWER
RADIANS
REPLACE
RFILL
ROUND
RPAD
RTRIM
SECOND
SIGN
SIN
SINH
SOUNDEX
SQLMODE
SQRT
STAMP{*}
STDDEV
SUBDATE
SUBSTR
SUBTIME
SUM
SYSDBA{*}
TAN
TANH
TIME
TIME{*}
TIMEDIFF
TIMESTAMP
TIMESTAMP{*}
TIMEZONE{*}
TOP
TRANSACTION{*}
TRANSLATE
TRIM
TRUE{*}
TRUNC
UID{*}
UNION
UPPER
USER{*}
UTCDATE{*}
UTCDIFF{*}
VALUE
VARIANCE
WEEKOFYEAR
YEAR
||
&
The names flagged with {*} relate to value specifications.
Function (function_spec)
Set Function (set_function_spec)
Name of a Database Function (dbfunction_name)
Specifying Values (extended_value_spec)
Syntax List
SQL Reference Manual
Functions: Overview 