There are examples on the Internet.





Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Jeanine Blomberg is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Sapan Patel
[mailto:oracledba-ezmlmshield-x11008910.[Email address protected]
Sent: Thursday, June 28, 2007 4:58 AM
To: LazyDBA Discussion
Subject: Condition in CASE statement


Hi Gurus,



Can any one please tell me how put the following condition in a CASE
statement.




If all "some_Id" is Y, then A,

else if any some_Id is Y, then B.

else C



where "some_Id" is a column and A, B and C are the target values that I
want to populate based on the given condition above.





Thanks & Regards,

SK


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

Oracle LazyDBA home page