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.

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
Have you deleted anything from dual recently????? (voice of experiance!)

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

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

Current Time: Sat Nov 28 08:04:55 CST 2015

Total time taken to generate the page: 0.09024 seconds