IF NOT EXISTS SELECT ...

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