Single row Functions

• If in table, use them by surrounding the column name

Case conversion

• UPPER
• LOWER
• INITCAP

Character Manipulation

• SUBSTR
• INSTR
• LENGTH
• LPAD/RPAD
• LTRIM/RTRIM
• REPLACE

Numeric

• ROUND
• TRUNC
• MOD
• ABS

Date

• MONTHS_BETWEEN
• ADD_MONTHS
• NEXT_DAY
• …

Type conversion

• TO_DATE
• TO_CHAR
• TO_NUMBER

Misc

• NVL
• NVL2
• DECODE
• CASE