|
Aggregate functions
|
AVG
COUNT
MAX
MIN
STDDEV
SUM
VARIANCE
|
|
Conversion functions
|
CAST
TO_CHAR
TO_DATE
TO_NUMBER
TO_TIMESTAMP
|
|
Geometric functions
|
AREA
BOX
CENTER
CIRCLE
DIAMETER
HEIGHT
ISCLOSED
ISOPEN
LENGTH
LSEG
NPOINTS
PATH
PCLOSE
POINT
POLYGON
POPEN
RADIUS
WIDTH
|
|
Network functions
|
ABBREV
BROADCAST
HOST
MASKLEN
NETMASK
NETWORK
TEXT
TRUNC
|
|
Numerical functions
|
ABS
ACOS
ASIN
ATAN
ATAN2
CBRT
CEIL
COS
COT
DEGREES
EXP
FLOOR
LN
LOG
PI
POW or POWER
RADIANS
RANDOM
ROUND
SIN
SQRT
TAN
TRUNC
|
|
SQL functions
|
CASE WHEN
COALESCE
NULLIF
|
|
String functions
|
ASCII
CHR
INITCAP
LENGTH, CHAR_LENGTH,or CHARACTER_LENGTH
LOWER
LPAD
LTRIM
OCTET_
POSITION
STRPOS
RPAD
RTRIM
SUBSTRING
SUBSTR
TRANSLATE
TRIM
UPPER
|
|
Time functions
|
AGE
CURRENT_
CURRENT_TIME
CURRENT_TIMESTAMP
DATE_PART
DATE_TRUNC
EXTRACT
ISFINITE
NOW
TIMEOFDAY
TIMESTAMP
|
|
User functions
|
CURRENT_USER
SESSION_USER
USER
|
|
Other functions
|
ARRAY_DIMS
|
