top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

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

+3 votes
46 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
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...