Home » Server Options » Text & interMedia » Unable to retrieve any rows from Dual
Unable to retrieve any rows from Dual [message #76131] Tue, 19 October 2004 01:02 Go to next message
S Ganguly
Messages: 2
Registered: October 2004
Junior Member
When i issue

'select sysdate from dual;'

it returns

'No rows selected'

But table dual is exists with one column DUMMY.

Please provide me some solution so that it returns value.

 

Report message to a moderator

Re: Unable to retrieve any rows from Dual [message #76138 is a reply to message #76131] Sun, 28 November 2004 08:46 Go to previous message
Just John
Messages: 69
Registered: November 2004
Member
Have you deleted anything from dual recently????? (voice of experiance!)

Dual should have 1 column 'DUMMY' and 1 record 'X'.

Try that!

Report message to a moderator

Previous Topic: DBMS JOBS
Next Topic: Can Oracle Text/Oracle ultra Search Works in this case?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jun 16 03:34:04 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.