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: problems in starting text mining in Oracle 10g
Next Topic: Oracle Intermedia
Goto Forum:

Current Time: Sat Aug 19 04:29:29 CDT 2017

Total time taken to generate the page: 0.06639 seconds