Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL Question

SQL Question

From: Paul Wiles <john_at_adzi.com>
Date: Sun, 18 Apr 1999 16:24:39 +0100
Message-ID: <3719f7d1@newsread3.dircon.co.uk>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US