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
Member
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: Fri Mar 29 09:50:47 CDT 2024