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!
Hello,
In my query (inside a procedure )
I need..
select … where
a.cust=b.cust
AND
IF var1='Y' THEN
branch in (select branch_name from branches)
ELSE
branch=var2;
ENDIF;
This is the logic,
Any idea how to implement it ?