Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Case statement using instr with additional clause

888181Nov 14 2011 — edited Nov 14 2011
Hi this is my code:
Update table_1

SET Financial_Review = ( case when instr(Judgement||Liquidation||under_admin,'Y') > 0 then  'Y' else 'N' end)
This works perfectly. I now need to add another factor Debt_Review. The possible option is Debt_Review 0 or 1 where 1 implies Y and 0 implies N.

I basically am looking to include Debt_review in the above update statement. If Judgement or Liquidation or under_admin are Y or Debt_Review is 1 then Financial_Review = Y else N.

Thanks in advance!!!

Banner:
Oracle Database 11g Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
"CORE 11.2.0.2.0 Production"
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
This post has been answered by prakash on Nov 14 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 12 2011
Added on Nov 14 2011
#11g
2 comments
3,727 views