OraFAQ Forum: SQL & PL/SQL » Nothing selected from dual........

Home » SQL & PL/SQL » SQL & PL/SQL » Nothing selected from dual........

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.....

Report message to a moderator

Re: Nothing selected from dual........ [message #19521 is a reply to message #19520]

Sat, 23 March 2002 05:33

Senthil
Messages: 68
Registered: December 1999

Member

make sure that you have 1 row in dual table. Otherwise you would get "no rows selected" for anything issuing against the table...

Report message to a moderator

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?????

Report message to a moderator

Previous Topic:	ORA-01536: sPACE QUOTA EXCEED FOR TABLESPACE
Next Topic:	one stupid question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 10:37:10 CDT 2024