Nothing selected from dual........ [message #19520] |
Sat, 23 March 2002 02:14 |
Amit
Messages: 166 Registered: February 1999
|
Senior Member |
|
|
If I write the statement as :
Select sysdate from dual;
I get the message "no rows selected"
Can anybody tell me where the problem is.....
|
|
|
|
Re: Nothing selected from dual........ [message #19525 is a reply to message #19521] |
Sat, 23 March 2002 23:11 |
Amit
Messages: 166 Registered: February 1999
|
Senior Member |
|
|
Thanks man senthil.....Actually some days back i created another table with the name as dual and i forgot to delete it.....That's why it was giving me error.....Now its working fine....I am planning to write my DBA exam. If u have any brain dumps/sts exams or if u can tell me where can i get those it will be nice of u?????
|
|
|