Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: IF NOT EXISTS SELECT ...
Try it like this :
IF NOT EXISTS ( SELECT * FROM table WHERE col = value) THEN
good luck!
Stephen Cook
In article <53vsnr$7uf_at_newstoo.ericsson.se>, eraarm_at_hfera.ericsson.se wrote:
>I would like to test the existence of rows as condition
>in a PL/SQL if-clause:
> IF NOT (EXISTS SELECT * FROM table WHERE col = value) THEN
> ...
> END IF;
>
>but Oracle complains about the syntax. I tried different variations
>with/without parentheses without success.
>Apparently, the EXISTS operator may only be used in subqueries.
>Can you help?
>
>-- Armin
>_______________________________________________________________________
>Armin.Seidel_at_hfera.ericsson.se KI/ERA/LK/NK +46(0)8-404 2456
> extr.qraarmi@memo.ericsson.se http://www.hfera.ericsson.se:/~eraarm/
> armin_at_independent.se www.independent.se +46(0)70-7277822
>
#****************************************************************************# +DISCLAIMER: Unless indicated otherwise, everything in this note is personal + +opinion, and not an official statement of Molecular Simulations Inc. + #****************************************************************************#Received on Tue Oct 15 1996 - 00:00:00 CDT