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

From: Dmytro Dekhtyaryuk <dekhtyaryuk_at_materna.de>
Date: Tue, 25 Oct 2005 14:10:18 +0200
Message-ID: <djl7bc$mbt$1@pentheus.materna.de>

"Son KwonNam" <kwon37xi_at_ihatespam.xxx> schrieb im Newsbeitrag news:djl5im$9bb$1_at_news2.kornet.net...
> Is there a insert statement which has no effect?
>
> I tried "Insert into dual values('1')" but I does not work.
> Any idea?
>
> Thanks.
> KwonNam.

You can : connect /as sysdba.
But you shouldn't do this.
See answer from Tom Kyte - you change the Data Dictionary !

http://asktom.oracle.com/pls/ask/f?p=4950:8:9931949195808393844::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1562813956388

Regards
Dmytro Dekhtyaryuk Received on Tue Oct 25 2005 - 07:10:18 CDT