Home > Oracle/PLSQL > Built-In Functions Function Navigation: Built-In Functions - Alphabetical Built-In Functions - Category Oracle/PLSQL: Built-In Functions - Category Character / String Functions Ascii AsciiStr Chr Compose Concat Concat with || Convert Decompose Dump Initcap Instr Length Lower Lpad Ltrim Replace Rpad Rtrim Soundex Substr Translate Trim Upper VSize Conversion Functions Bin_To_Num Cast CharToRowid From_Tz HexToRaw NumToDSInterval NumToYMInterval RawToHex To_Char To_Clob To_Date To_DSInterval To_Lob To_Multi_Byte To_NClob To_Number To_Single_Byte To_Timestamp To_Timestamp_Tz To_YMInterval Advanced Functions BFilename Cardinality Case Statement Coalesce Decode Group_ID Lag Lead LNNVL NANVL NULLIF NVL NVL2 Sys_Context Uid User UserEnv Mathematical Functions Abs Acos Asin Atan Atan2 Avg Bin_To_Num BitAnd Ceil Corr Cos Cosh Covar_pop Covar_samp Count Cume_Dist Dense_Rank Exp Extract Floor Greatest Least Ln Log Max Median Min Mod Power Rank Remainder Round (numbers) Round (dates) Sign Sin Sinh Sqrt StdDev Sum Tan Tanh Trunc (numbers) Trunc (dates) Var_pop Var_samp Variance Date Functions Add_Months Current_Date Current_Timestamp DbTimeZone From_Tz Last_Day LocalTimestamp Months_Between New_Time Next_Day Round SessionTimeZone Sysdate To_Date Trunc Tz_Offset SysTimestamp To_Char Error Functions SQLCODE SQLERRM Miscellaneous Functions Retrieve user ID from the current Oracle session Retrieve the session ID for the user logged in
