聚 合 函 数 ( Aggregate Functions)
AVG
BOOL_AND
BOOL_OR
COUNT
GROUP_CONC
AT
MAX
MIN
SUM
SELECTIVI
TY
STDDEV_P
OP
STDDEV_SA
MP
VAR_POP
VAR_SAMP
数 值 函 数 ( Numeric Functions)
ABS
ACOS
ASIN
ATAN
COS
COT
SIN
TAN
ATAN
2
BITA
ND
BITO
R
BITX
OR
MOD
CEILIN
G
DEGRE
ES
EXP
FLOOR
LOG
LOG10
RADIA
NS
SQRT
PI
POWE
R
RAND
RANDOM_U
UID
ROUND
ROUNDMAGI
C
SECURE_RA
ND
SIGN
ENCRYPT
DECRYPT
HASH
TRUNCATE
COMPRESS
EXPAND
ZERO
字 符 串 函 数 ( String Functions)
ASCII
BIT_LENGTH
LENGTH
OCTET_LENG
TH
CHAR
CONCAT
DIFFERENCE
HEXTORAW
RAWTOHEX
INSTR
LEFT
RIGHT
LOCATE
POSITION
LPAD
RPAD
LTRIM
RTRIM
TRIM
REGEXP_REPLA
CE
SPACE
STRINGDECO
DE
STRINGENCO
DE
STRINGTOUT
F8
SUBSTRING
UTF8TOSTRI
NG
XMLATTR