Oracle PL/SQL Functions
Character / String Functions
| Ascii | Chr | Concat | Concat || |
| Dump | Initcap | Instr | Length |
| Lower | Lpad | Ltrim | Replace |
| Rpad | Rtrim | Soundex | Substr |
| Translate | Trim | Upper | VSize |
Conversion Functions
| Bin_To_Num | From_Tz | NumToDSInterval | NumToYMInterval |
| To_Char | To_Date | To_Lob | To_Number |
Advanced Functions
| BFilename | Coalesce | Decode | Group_ID |
| Lag | Lead | NULLIF | NVL |
| NVL2 | Sys_Context | Uid | User |
Mathematical Functions
| Avg | Ceil | Count | Cume_Dist |
| Dense_Rank | Exp | Extract | Floor |
| Greatest | Least | Max | Median |
| Min | Mod | Power | Rank |
| Remainder | Round | Sign | Sqrt |
| Sum | Trunc |
Date Functions
| Add_Months | Current_Date | Current_Timestamp | From_Tz |
| LocalTimestamp | Months_Between | SessionTimeZone | Round |
| Sysdate | SysTimestamp | To_Char | To_Date |
| Trunc |