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

Home -> Community -> Usenet -> c.d.o.server -> Re: Is there a insert statement which has no effect?

Re: Is there a insert statement which has no effect?

From: Carlos <miotromailcarlos_at_netscape.net>
Date: 25 Oct 2005 05:34:54 -0700
Message-ID: <1130243694.796808.92450@g47g2000cwa.googlegroups.com>


>>Is there a insert statement which has no effect?

Maybe something like this?

sql> create table dummy ( dummy1 varchar2(1));

Tabla creada.

sql> insert into dummy select 'x' from dual where 1=0;

0 filas creadas.

sql>

Cheers.

Carlos. Received on Tue Oct 25 2005 - 07:34:54 CDT

Original text of this message

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