How do u implement the If statement in the Select Statement?

Answer 1

We can implement the if statement in the select statement by using the Decode statement.

e.g select DECODE (EMP_CAT,'1','First','2','Second'Null);

--Here the Null is the else statement where null is done .