Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Exist clause in PL/SQL
Hi,
Is there in PL/SQL any replacement for SQL-Server's "If exist/If not
exist" clause?
I need to do something like : if not exists (select * from Table1
where Field1=...) Insert into Table1 (Field1, Field2,...) values (...,
...,...)
thanks Received on Mon Nov 12 2001 - 09:41:53 CST
![]() |
![]() |