List of function names and value specifications:
ABS
ACOS
ADDDATE
ADD_MONTHS
ADDTIME
ALL
ALPHA
ASCII
ASIN
ATAN
ATAN2
AVG
CASE
CEIL
CHAR
CHR
CONCAT
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
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)
SQL Syntax
SQL Reference Manual
