Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> SQL Question
I'm new to Oracle from Sybase.
What's the Oracle equivalent to the Sybase:
if exists (select * from TABLE)
else
?
At the moment i'm setting a variable to count(*) and then doing an
IF var > 0 THEN
ELSE
It's rather cumbersome.
Thanks
Paul Received on Sun Apr 18 1999 - 10:24:39 CDT
![]() |
![]() |