Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
CRM On Demand Analytics and Reports
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Jun 20, 2011 3:05 PM by
neeed help to write a case statement
Jun 20, 2011 3:05 PM
I want to write a case statement such that
i have four name sunny,katie,linda,scott in which sunny is the manager
the rek is that under sunny if katie,linds scott falls then i need to show "yes" in coloumn other wise "no"
case when cn1.sunny=cn2 in(katie,linda,scott) then 'y' else 'n'
Edited by: user13001889 on Jun 20, 2011 1:04 PM
This content has been marked as final.
Show 0 replies