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

Credit goes to: http://www.techonthenet.com/oracle/functions/index.php