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

From: Son KwonNam <kwon37xi_at_ihatespam.xxx>
Date: Tue, 25 Oct 2005 22:24:27 +0900
Message-ID: <djlbgd$av5$1@news2.kornet.net>

insert into dummy select 'x' from dual where 1=0; is perfect answer for me,

But anyway, everybody's answers are helpful for me.

Thank you, All.

KwonNam.

Carlos wrote:

>>>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 - 08:24:27 CDT