RE: DML on dual?
- From: Tanel Poder <tanel.poder.003@xxxxxxx>
- To: darrah.john@xxxxxxxxx, "'Herring Dave - dherri'" <Dave.Herring@xxxxxxxxxx>
- Date: Sat, 14 Apr 2007 13:07:15 +0800
Good finding...
This sqlplus'es "select from dual for update" never made sense to me..
Tanel.
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of John Darrah
Sent: Friday, April 13, 2007 02:45
To: Herring Dave - dherri
Cc: oracle-l@xxxxxxxxxxxxx
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
Other related posts:
