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
sidd_411
Messages: 30
Registered: March 2008
Member
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.


regards,
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: 68712
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Don't touch dual.
Dual is magic.

Read AskTom All about the DUAL table

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


Current Time: Thu Nov 14 05:53:49 CST 2024