Oracle PL/SQL Funktionen Datum/Uhrzeit Funktionen ADD_MONTHSCURRENT_DATECURRENT_TIMESTAMPDBTIMEZONEEXTRACTFROM_TZ LAST_DAYLOCALTIMESTAMPMONTHS_BETWEENNEW_TIMENEXT_DAYROUND-FOR-DATE SESSIONTIMEZONESYSDATESYSTIMESTAMPTRUNC-FOR-DATETZ_OFFSET Konvertierungs Funktionen BIN_TO_NUMCASTCHARTOROWIDCONVERTDECOMPOSEHEXTORAWNUMTODSINTERVAL NUMTOYMINTERVALRAWTOHEXTO_CHARTO_CLOBTO_DATETO_DSINTERVALTO_LOB TO_MULTI_BYTETO_NCLOBTO_NUMBERTO_SINGLE_BYTETO_TIMESTAMP_TZTO_TIMESTAMPTO_YMINTERVAL Erweiterte Funktionen BFILENAMECARDINALITYCOALESCEDECODEEMPTY_BLOBEMPTY_CLOB TEXTGROUP_IDLNNVLNANVLNULLIFNVL NVL2UIDUSERUSERENV Analytische Funktionen CORRCOVAR_POPCOVAR_SAMPCUME_DISTDENSE_RANKFIRST_VALUE LAGLAST_VALUELEADLISTAGGNTH_VALUERANK STDDEVVAR_POPVAR_SAMPVARIANCE String/Char Funktionen ASCIIASCIISTRCHRCOMPOSECONCATCONCAT-OPERATORDUMPINITCAPINSTRINSTR2INSTR4INSTRB INSTRCLENGTHLENGTH2LENGTH4LENGTHBLENGTHCLOWERLPADLTRIMNCHRREGEXP_INSTRREGEXP_LIKE REGEXP_REPLACEREGEXP_SUBSTRREPLACERPADRTRIMSOUNDEXSUBSTRTO_DATETRANSLATETRIMUPPERVSIZE Numerische/mathematische Funktionen ABSACOSASINATANATAN2AVGBITANDCEILCOSCOSHCOUNT EXPFLOORGREATESTLEASTLNLOGMAXMEDIANMINMODPOWER REGEXP_COUNTREMAINDERROUND-FOR-NUMBERSIGNSINSINHSQRTSUMTANTANHTRUNC-FOR-NUMBER