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 POWER

REGEXP_COUNT REMAINDER ROUND-FOR-NUMBER SIGN SIN SINH SQRT 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

TEXT GROUP_ID LNNVL NANVL NULLIF NVL

NVL2 UID USER USERENV