Oracle DECODE function
Oracle decode function allow to transform data values at retrieval time.
DECODE(expr, search, result
[, search, result ]...
[, default ]
We have a column named Floor, with values of GF, FF, SF and TF. When we run SQL queries, we want to transform these values into Ground Floor, First Floor, Second Floor and Third Floor.