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

Report message to a moderator

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: 68761
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jul 12 02:33:35 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.