Oracle PL/SQL Funktionen

Analytische Funktionen

CORR COVAR_POP COVAR_SAMP CUME_DIST DENSE_RANK FIRST_VALUE

LAG LAST_VALUE LEAD LISTAGG NTH_VALUE RANK

STDDEV VAR_POP VAR_SAMP VARIANCE

String/Char Funktionen

Numerische/mathematische Funktionen

ABS ACOS ASIN ATAN ATAN2 AVG BITAND CEIL COS COSH COUNT EXP

FLOOR GREATEST LEAST LN LOG MAX MEDIAN MIN MOD ORDER-BY POWER REGEXP_COUNT

REMAINDER ROUND-FOR-NUMBER SIGN SIN SINH SQRT SUBQUERIES SUM TAN TANH TRUNC-FOR-NUMBER

Datum/Uhrzeit Funktionen

ADD_MONTHS CURRENT_DATE CURRENT_TIMESTAMP DBTIMEZONE EXTRACT FROM_TZ

LAST_DAY LOCALTIMESTAMP MONTHS_BETWEEN NEW_TIME NEXT_DAY ROUND-FOR-DATE

SESSIONTIMEZONE SYSDATE SYSTIMESTAMP TRUNC-FOR-DATE TZ_OFFSET

Konvertierungs Funktionen

Erweiterte Funktionen

BFILENAME CARDINALITY COALESCE DECODE EMPTY_BLOB EMPTY_CLOB

SYS_CONTEXT GROUP_ID LNNVL NANVL NULLIF NVL

NVL2 UID USER USERENV