Oracle Database: SQL, RMAN, and IDMS Fundamentals

INSTR returns the numeric position of a named character.

NVL2 returns the first non-null expression in the expression list.

TRUNCATE rounds the column, expression, or value to n decimal places.

DECODE translates an expression after comparing it to each search value.

TRIM trims the heading or trailing characters (or both) from a character string.

NULLIF compares two expressions and returns null if they are equal, or the first expression if they are not equal.