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