Oracle DECODE function

Oracle DECODE function Oracle decode function allow to transform data values at retrieval time. Syntax : DECODE(expr, search, result [, search, result ]… [, default […]