Функции Oracle PL/SQL Аналитические CORRCOVAR_POPCOVAR_SAMPCUME_DISTDENSE_RANKFIRST_VALUE LAGLAST_VALUELEADLISTAGGNTH_VALUERANK STDDEVVAR_POPVAR_SAMPVARIANCE Символьные / строчные ASCIIASCIISTRCHRCOMPOSECONCATCONCAT-OPERATORDUMPINITCAPINSTRINSTR2INSTR4INSTRB INSTRCLENGTHLENGTH2LENGTH4LENGTHBLENGTHCLOWERLPADLTRIMNCHRREGEXP_INSTRREGEXP_LIKE REGEXP_REPLACEREGEXP_SUBSTRREPLACERPADRTRIMSOUNDEXSUBSTRTO_CHARTRANSLATETRIMUPPERVSIZE Числовые / математические ABSACOSASINATANATAN2AVGBITANDCEILCOSCOSHCOUNT EXPFLOORGREATESTLEASTLNLOGMAXMEDIANMINMODPOWER REGEXP_COUNTREMAINDERROUND-FOR-NUMBERSIGNSINSINHSQRTSUMTANTANHTRUNC-FOR-NUMBER Дата / время ADD_MONTHSCURRENT_DATECURRENT_TIMESTAMPDBTIMEZONEEXTRACTLAST_DAY LOCALTIMESTAMPMONTHS_BETWEENNEW_TIMENEXT_DAYROUND-FOR-DATESESSIONTIMEZONE SYSDATESYSTIMESTAMPTO_DATETRUNC-FOR-DATETZ_OFFSET Преобразование BIN_TO_NUMCASTCHARTOROWIDCONVERTDECOMPOSEFROM_TZHEXTORAW NUMTODSINTERVALNUMTOYMINTERVALRAWTOHEXTO_CLOBTO_DSINTERVALTO_LOBTO_MULTI_BYTE TO_NCLOBTO_NUMBERTO_SINGLE_BYTETO_TIMESTAMP_TZTO_TIMESTAMPTO_YMINTERVAL Вспомогательные BFILENAMECARDINALITYCOALESCEDECODEEMPTY_BLOBEMPTY_CLOB GROUP_IDLNNVLNANVLNULLIFNVLNVL2 SQLCODESQLERRMSYS_CONTEXTUIDUSERUSERENV