1 | number functions: abs, ceil, cos, cosh, exp, floor, ln, log, mod, power, round, sign, sin, sinh, sort, tan, tanh, trunc |
2 | character functions: chr, concat, initcap, lower, lpad, ltrim, replace, rpad, rtrim, soundex, substr, substrb, translate, upper, ascii, intstr, instrb, length, lengthb |
3 | date functions: add_months, last_day, months_between, new_time, next_day, round, sysdate, trunc |
4 | conversion functions: chartorowid, convert, hextoraw, rawtohex, rowidtochar, to_char, to_date, to_label, to_number |
5 | group functions: avg, count, min,max, stddev, sum, variance |