Implement the If statement in the Select Statement

On June 22, 2009 / By admin / In Oracle / Reply

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

 

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 .

Reply

Spam Protection by WP-SpamFree


SEO Powered By SEOPressor