EXIST, NOT EXIST problem

Hi,

    how can i translate this pseudocode in PL/SQL?

if EXISTS(select ......) then

elsif NOT EXISTS(select....) then

end if;

I think one way is the sequent:

Condition 1

select ... into var1 where ....

Condition 2

select ... into var2 where.....

and so the code is:

if (var1 <> 0 ) then

elsif (var2 = 0) the

end if;

...but it's a problem, because the select fails if no return a value INTO the variable!!

How can i do??

Thank
enrico brighi Received on Wed Jun 20 2001 - 09:01:22 CEST