Skip to Main Content

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!

Explanation of instr function

888181Nov 1 2011 — edited Nov 1 2011
Hi,

I was assisted with a query and received the the following code. The code did what I wanted it to do but I don't really understand how it works. I tried googling but the examples are different to this one and don't contain the > 0 or || (Which I assume references a column. Could someone please explain it to me.
 SET Financial_Review = ( case when instr(Debt_Review||Judgement||Liquidation||under_admin,'Y') > 0 then  'Y' else 'N' end) 
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 Karthick2003 on Nov 1 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 29 2011
Added on Nov 1 2011
3 comments
417 views