Oracle Decode Function
Oracle Decode Function: Oracle DECODE() function compares the first argument with the second argument. IF they are equal, the function returns the third argument otherwise return default value.
The Oracle/PLSQL DECODE function has the functionality of an IF-THEN-ELSE statement:
SELECT DECODE (1, 1, 'ONE', …