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.        +
#****************************************************************************#