How Do U Implement The If Statement In The Select Statement ?

1.	How Do U Implement The If Statement In The Select Statement ?
Answer» 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 . 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 .

Answer»

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 .

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 .

Discussion