top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

+3 votes
52 views
How do u implement the If statement in the Select Statement?
posted Oct 3, 2014 by Suchithra

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
 
Best 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 .

answer Oct 6, 2014 by Arun Gowda
...