Contents - Built-in system functions
FLOOR function.................................................................................................128
HOUR function.................................................................................................. 128
IDENTITY_VAL_LOCAL function...................................................................... 128
INTEGER function............................................................................................. 130
LCASE or LOWER function.............................................................................. 131
LENGTH function.............................................................................................. 131
LN or LOG function........................................................................................... 131
LOG10 function................................................................................................. 132
LOCATE function...............................................................................................132
LTRIM function.................................................................................................. 133
MAX function..................................................................................................... 133
MIN function...................................................................................................... 134
MINUTE function............................................................................................... 134
MOD function.....................................................................................................135
MONTH function................................................................................................ 135
NULLIF expressions.......................................................................................... 135
PI function..........................................................................................................135
RADIANS function............................................................................................. 136
RANDOM function............................................................................................. 136
RAND function...................................................................................................136
ROW_NUMBER function...................................................................................136
RTRIM function..................................................................................................137
SECOND function..............................................................................................137
SESSION_USER function................................................................................. 138
SIGN function.................................................................................................... 138
SIN function....................................................................................................... 138
SINH function.................................................................................................... 138
SMALLINT function........................................................................................... 139
SQRT function................................................................................................... 139
SUBSTR function.............................................................................................. 140
SUM function..................................................................................................... 140
TAN function......................................................................................................141
TANH function................................................................................................... 141
TIME function.................................................................................................... 141
TIMESTAMP function........................................................................................ 142
TRIM function.................................................................................................... 143
UCASE or UPPER function...............................................................................144
USER function................................................................................................... 144
VARCHAR function........................................................................................... 144
XMLEXISTS operator........................................................................................ 145
XMLPARSE operator.........................................................................................146
XMLQUERY operator........................................................................................ 147
XMLSERIALIZE operator.................................................................................. 149
YEAR function................................................................................................... 150
SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY system function......... 151
SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS system function............. 152
SYSCS_UTIL.SYSCS_GET_USER_ACCESS system function....................... 152
SYSCS_UTIL.SYSCS_GET_XPLAIN_MODE system function.........................153
SYSCS_UTIL.SYSCS_GET_XPLAIN_SCHEMA system function.................... 153