PLSQL : If variable IN subquery

Question

Is it possibile in PL/SQL function something like

IF xVar IN (SELECT yVar
            FROM....)
THEN...

this? Thank you

See a couple ways here: http://stackoverflow.com/questions/13217600/if-exists-condition-not-working-with-plsql — MarCrazyness, Jan 18 '14 at 00:03

score 3 · Accepted Answer · answered Jan 17 '14 at 18:29

3

No, you will probably have to so something like

select count(*) 
into foo 
from blah
where yVar = xVar

if foo > 0 then ...

Or you could make a function that returns boolean if this is something you'd use often

answered Jan 17 '14 at 18:29

Joel

score 0 · Answer 2 · answered Jan 17 '14 at 18:52

0

You can use FOR-IN with your implicit cursor. I know only IF-THEN-ELSE operator with IF expression.

answered Jan 17 '14 at 18:52

Vlad Dekhanov

2 Answers2