ПРАКТИЧЕСКАЯ РАЗРАБОТКА. ФУНКЦИИ В ORACLE

Функции по категориям

Символьные / строчные

ASCII CHR CONCAT CONCAT-OPERATOR DUMP INITCAP INSTR INSTR2 INSTR4 INSTRB

INSTRC LENGTH LENGTH2 LENGTH4 LENGTHB LENGTHC LOWER LPAD LTRIM NCHR

REPLACE RPAD RTRIM SOUNDEX SUBSTR TO_CHAR TRANSLATE TRIM UPPER VSIZE

Числовые / математические

ABS ACOS ASIN ATAN ATAN2 AVG BITAND CEIL CORR COS COSH COUNT COVAR_POP COVAR_SAMP CUME_DIST

DENSE_RANK EXP EXTRACT FLOOR GREATEST LEAST LN LOG MAX MEDIAN MIN MOD POWER RANK REMAINDER

ROUND-FOR-NUMBER SIGN SIN SINH SQRT STDDEV SUM TAN TANH TRUNC-FOR-NUMBER VARIANCE VAR_POP VAR_SAMP

Дата / время

ADD_MONTHS CURRENT_DATE CURRENT_TIMESTAMP DBTIMEZONE FROM_TZ-2 LAST_DAY

LOCALTIMESTAMP MONTHS_BETWEEN NEW_TIME NEXT_DAY ROUND-FOR-DATE SESSIONTIMEZONE

SYSDATE SYSTIMESTAMP TO_DATE TRUNC-FOR-DATE TZ_OFFSET

Преобразование

ASCIISTR BIN_TO_NUM CAST CHARTOROWID COMPOSE CONVERT DECOMPOSE FROM_TZ

HEXTORAW NUMTODSINTERVAL NUMTOYMINTERVAL RAWTOHEX TO_CLOB TO_DSINTERVAL TO_LOB TO_MULTI_BYTE

TO_NCLOB TO_NUMBER TO_SINGLE_BYTE TO_TIMESTAMP TO_TIMESTAMP_TZ TO_YMINTERVAL

Дополнительные

BFILENAME CARDINALITY COALESCE DECODE EMPTY_BLOB EMPTY_CLOB GROUP_ID

LAG LEAD LISTAGG LNNVL NANVL NULLIF NVL

NVL2 SYS_CONTEXT UID USER USERENV