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

Home -> Community -> Usenet -> c.d.o.misc -> Exist clause in PL/SQL

Exist clause in PL/SQL

From: Yaron Avior <yavior_at_mercury.co.il>
Date: 12 Nov 2001 07:41:53 -0800
Message-ID: <1b00d968.0111120741.6e92e5fb@posting.google.com>


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

Original text of this message

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