BIT_AND()
BIT_OR()
BIT_XOR()
BIT_COUNT()
ASCII()
BIN()
BIT_LENGTH()
CHAR_LENGTH()
CHARACTER_LENGTH()
LENGTHB()
LENGTH()
CHR()
CONCAT()
CONCAT_WS()
ELT()
FIELD()
FIND_IN_SET()
FROM_BASE64()
INSERT()
INSTR()
LCASE()
LOWER()
LEFT()
LOCATE()
LPAD()
LTRIM()
MID()
OCTET_LENGTH()
POSITION()
REPEAT()
REPLACE()
REVERSE()
RIGHT()
RPAD()
RTRIM()
SPACE()
STRCMP()
SUBSTR()
SUBSTRING()
SUBSTRING_INDEX()
TO_BASE64()
TRANSLATE()
TRIM()
UCASE()
UPPER()
REGEXP_COUNT()
REGEXP_INSTR()
REGEXP_LIKE()
REGEXP_REPLACE()
REGEXP_SUBSTR()
ABS()
ACOS()
ASIN()
ATAN()
ATAN2()
CEIL()
CONV()
COS()
COT()
CRC32()
DEGREES()
DRANDOM()
DRAND()
EXP()
FLOOR()
HEX()
LN()
LOG2()
LOG10()
MOD()
PI()
POW()
POWER()
RADIANS()
RANDOM()
RAND()
ROUND()
SIGN()
SIN()
SQRT()
TAN()
TRUNC()
TRUNCATE()
WIDTH_BUCKET()
ADDDATE()
DATE_ADD()
ADDTIME()
ADD_MONTHS()
CURDATE()
CURRENT_DATE()
CURRENT_DATETIME()
NOW()
CURTIME()
CURRENT_TIME()
CURRENT_TIMESTAMP()
LOCALTIME()
LOCALTIMESTAMP()
DATE()
DATEDIFF()
DATE_SUB()
SUBDATE()
DAY()
DAYOFMONTH()
DAYOFWEEK()
DAYOFYEAR()
EXTRACT()
FROM_DAYS()
FROM_TZ()
FROM_UNIXTIME()
HOUR()
LAST_DAY()
MAKEDATE()
MAKETIME()
MINUTE()
MONTH()
NEW_TIME()
QUARTER()
SEC_TO_TIME()
SECOND()
TIME()
TIME_TO_SEC()
TIMEDIFF()
TIMESTAMP()
TO_DAYS()
TZ_OFFSET()
UNIX_TIMESTAMP()
UTC_DATE()
UTC_TIME()
WEEK()
WEEKDAY()
YEAR()
JSON_ARRAY()
JSON_OBJECT()
JSON_KEYS()
JSON_DEPTH()
JSON_LENGTH()
JSON_VALID()
JSON_TYPE()
JSON_QUOTE()
JSON_UNQUOTE()
JSON_PRETTY()
JSON_SEARCH()
JSON_EXTRACT()
JSON_CONTAINS_PATH()
JSON_CONTAINS()
JSON_MERGE_PATCH()
JSON_MERGE_PRESERVE()
JSON_MERGE()
JSON_ARRAY_APPEND()
JSON_ARRAY_INSERT()
JSON_INSERT()
JSON_SET()
JSON_REPLACE()
JSON_REMOVE()
BIT_TO_BLOB()
BLOB_FROM_FILE()
BLOB_LENGTH()
BLOB_TO_BIT()
CHAR_TO_BLOB()
CHAR_TO_CLOB()
CLOB_FROM_FILE()
CLOB_LENGTH()
CLOB_TO_CHAR()
CAST()
DATE_FORMAT()
FORMAT()
STR_TO_DATE()
TIME_FORMAT()
TO_CHAR()
TO_DATE()
TO_DATETIME()
TO_DATETIME_TZ()
TO_NUMBER()
TO_TIME()
TO_TIMESTAMP()
TO_TIMESTAMP_TZ()
AVG()
COUNT()
CUME_DIST()
DENSE_RANK()
FIRST_VALUE()
GROUP_CONCAT()
LAG()
LAST_VALUE()
LEAD()
MAX()
MEDIAN()
MIN()
NTH_VALUE()
NTILE()
PERCENT_RANK()
RANK()
ROW_NUMBER()
STDDEV()
STDDEV_POP()
STDDEV_SAMP()
SUM()
VARIANCE()
VAR_POP()
VAR_SAMP()
JSON_ARRAYAGG()
JSON_OBJECTYAGG()
INCR()
DECR()
INST_NUM()
ORDERBY_NUM()
GROUPBY_NUM()
CHARSET()
COERCIBILITY()
COLLATION()
DATABASE()
SCHEMA()
DBTIMEZONE()
DEFAULT()
DISK_SIZE()
INDEX_CARDINALITY()
INET_ATON()
INET_NTOA()
LAST_INSERT_ID()
LIST_DBS()
ROW_COUNT()
SESSIONTIMEZONE()
USER()
SYSTEM_USER()
VERSION()
MD5()
SHA1()
SHA2()
COALESCE()
DECODE()
GREATEST()
IF()
IFNULL()
NVL()
ISNULL()
LEAST()
NULLIF()
NVL2()
SLEEP()
SYS_GUID()
conn_start()
conn_end()
query_exec_start()
query_exec_end()
obj_insert_start()
obj_insert_end()
obj_update_start()
obj_update_end()
obj_deleted_start()
obj_delete_end()
idx_insert_start()
idx_insert_end()
idx_update_start()
idx_update_end()
idx_delete_start()
idx_delete_end()
lock_acquire_start()
lock_acquire_end()
lock_release_start()
lock_release_end()
tran_commit()
tran_abort()
tran_start()
tran_deadlock()
pgbuf_hit()
pgbuf_miss()
io_write_start()
io_write_end()
io_read_start()
io_read_end()
sort_start()
sort_end()
This chapter covers the following API: