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 -> Re: If EXISTS before insert clause

Re: If EXISTS before insert clause

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Mon, 07 Feb 2005 17:13:17 +0100
Message-ID: <jq4f015c39827tvd1co0nrdc9tpeu96d3l@4ax.com>


On 7 Feb 2005 07:33:37 -0800, "JPike" <jpike_at_welcom.com> wrote:

>Oops. Also what about CREATE? The whole script contains ALTER, CREATE,
>DROP, and INSERTS. do all of the first three only work with Execute
>Immediate '... ?

select, insert, update, delete ---> ordinary DML, no problem

All the rest (CREATE, ALTER, DROP, TRUNCATE) ---> DDL, need execute immediate.

--
Sybrand Bakker, Senior Oracle DBA
Received on Mon Feb 07 2005 - 10:13:17 CST

Original text of this message

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