SQL features > Oracle functions

Aggregate functions

GROUPING(expression)
LISTAGG(EXPR [, DELIMITER]) WITHIN GROUP (ORDER BY FIELD)

Mathematical functions

ABS(NUMBER)
ACOS(NUMBER)
ASIN(NUMBER)
ATAN(NUMBER)
ATAN2(NUMBER)
BITAND(NUMBER, NUMBER)
CEIL(NUMBER)
COS(NUMBER)
COSH(NUMBER)
EXP(NUMBER)
FLOOR(NUMBER)
GREATEST(VALUE, [, VALUE])
GREATEST(VALUE, [, VALUE])
LN(NUMBER)
LOG(NUMBER, NUMBER)
MOD(NUMBER, NUMBER)
NANVL(NUMBER, NUMBER)
POWER(NUMBER, NUMBER)
REMINDER(NUMBER, NUMBER)
ROUND(NUMBER [, Digits])
SIGN(NUMBER)
SIN(NUMBER)
SINH(NUMBER)
SQRT(NUMBER)
TRUNC
TAN(NUMBER)
TANH(NUMBER)

Common functions

DECODE
WIDTH_BUCKET(EXPR, MIN_VALUE, MAX_VALUE, NUM_BUCKETS)
NULLIF
NVL
NVL2

String functions

CHR(NUMBER)
CONCAT(VARCHAR, VARCHAR)
INITCAP(VARCHAR)
INSTR(STRING, SUBSTRING [, POS])
LOWER(VARCHAR)
LPAD(EXPR, n [,BLANK])
LTRIM(EXP [, SET])
NLS_LOWER(EXPR, [,NLS_PARAM])
NLSSORT(EXPR, [,NLS_PARAM])
NLS_UPPER(EXPR, [,NLS_PARAM])
REGEXP_COUNT(EXPR, ,PATTERN[, POS, MATCH])
REGEXP_REPLACE(EXPR, [,PATTERN, REPLACE, POS, OCCURENCE, MATCH])
REGEXP_SUBSTR(EXPR, [,PATTERN, POS, OCCURENCE, MATCH])
REPLACE(EXPR, SEARCH [, REPLACE=‘’])
RPAD(EXPR, n [,BLANK=’ ’])
RTRIM(EXP [, SET=‘ ’])
SOUNDEX(VARCHAR)
SUBSTR(EXP, POS [,LEN])
SUBSTRB(BYTES, POS [,LEN])
SUBSTRC(UStr, POS [,LEN])
SUBSTR2(UCS2_STR, POS [,LEN])
SUBSTR4(UCS4_STR, POS [,LEN])
TO_CHAR(STRING, [FORMAT])
TO_NUMBER(STRING, [FORMAT])
TRANSLATE(EXP, FROM, TO)
TREAT(EXPR AS TYPE)
TRIM([LEADING|TRAILING|BOTH CHAR=’ ’ FROM] EXP)
UPPER(VARCHAR)

Date functions

TO_DATE(STRING, [FORMAT])
TO_TIMESTAMP(STRING, [FORMAT])
ADD_MONTHS(Date, Months)
EXTRACT(DATE_PART from DATETIME): DATETIME
LAST_DAY(Date)
MONTHS_BETWEEN(Date, Date)
SYSDATE