CASE AND DECODE : Two powerfull constructs of SQL - Oracle Forums

CASE and DECODE are the two widely used constructs in the SQL . And both have the functionality of an IF-THEN-ELSE statement to return some specified ... SQL> SELECT EMPNO,JOB , SAL , 2 DECODE (JOB,'ANALYST', SAL*1.2 ...

www.club-oracle.com