Home » RDBMS Server » Server Administration » SYS.DUAL status (Oracle 10g)
SYS.DUAL status [message #305766] Tue, 11 March 2008 22:54 Go to next message
Messages: 30
Registered: March 2008
Hi all,

How can I check sys.dual table for more than one row. Whenever I execute the sql query "insert into dual select * from dual, the result shows that the query is successful, but the count remains only one. Need assistance to sort out this.

Srinivas Smile
Re: SYS.DUAL status [message #305796 is a reply to message #305766] Wed, 12 March 2008 01:18 Go to previous message
Michel Cadot
Messages: 65143
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't touch dual.
Dual is magic.

Read AskTom All about the DUAL table

Previous Topic: CPU jan 2008
Next Topic: Snapshot errors
Goto Forum:

Current Time: Fri Aug 18 20:39:31 CDT 2017

Total time taken to generate the page: 1.04828 seconds