Hello guys, I am a newbie. I have a real quick question.

I am trying to write sql queries in SQL Plus 8.0. I have all the tables with data in Oracle8 Navigator already. Now, when I wrote a query statment in SQL Plus 8.0, it says that "no rows select". For some reason, it found the table but not the data of that table. Please show me how solve this problem. Do I need to connect anything between Oracle8 Navigator and SQL Plus 8.0?

Thanks a lot for helping.

HUY

Hi Huy,

Make sure that you have a row in that table

Cheers,

Cheers,

Dat

Programming and creating plugins and templates
Blog

Yes, my table have rows and columns and contain data. Thanks for replying.

Can you use the command 'desc table_name'?

Cheers,

Dat

Programming and creating plugins and templates
Blog

yes i can..when i type that command in... it shows the data structure of the table (name, null, type)..Thanks

This is strange. Can you provide with your query?

Cheers,

Dat

Programming and creating plugins and templates
Blog

I can't query at all. I typed "Select* From tablename", and it shows "no rows found".... Thanks... I am going hit the bed now, I'll check your message tomorrow. I am so frustrated. By the way, can I have your email. Thanks.

Still doesn't work... Any suggestions? Anybody?... Thanks..HUY

just check whether the table contains data.

select count(*) from tablename;

what output does it give?