RE: DML on dual?

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Sat, 14 Apr 2007 13:07:15 +0800
Message-id: <021801c77e52$c507f6c0$6701a8c0@windows01>

Good finding...

This sqlplus'es "select from dual for update" never made sense to me..

Tanel.

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of John Darrah
Sent: Friday, April 13, 2007 02:45
To: Herring Dave - dherri
Cc: oracle-l_at_freelists.org
Subject: Re: DML on dual?

Looks like this was something sqlplus did until version 10.2 to check if the database was read only or not. From a note I found on metalink: In 9.0 SQLPLUS was altered to issue an "select null from dual for update nowait"

statement to check if the target database is READ ONLY. This is no longer

required for 9.2 database and so SQLPLUS should no longer issue this SQL.

The doc says it was fixed in 10.2

Thanks
John

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Apr 14 2007 - 00:07:15 CDT