Re: Create Database Script..

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1094254962.59351_at_yasure>...
> Joel Garry wrote:
>
> > arijitchatterjee123_at_yahoo.co.in (Arijit Chatterjee) wrote in message news:<ea01504d.0409030431.aae3d7e_at_posting.google.com>...
> >
> >>Respected Sir,
> >>when I writing
> >>========================
> >>SQL> select * from tab;
> >>select * from tab
> >> *
> >>ERROR at line 1:
> >>ORA-00942: table or view does not exist
> >>=======================
> >>why this error is coming.
> >>Regards
> >>Arijit Chatterjee
> >
> >
> > Try select table_name from all_tables to see what you can select from.
> >
> > jg
> > --
> > @home.com is bogus.
> > Verrrry Suspicious:
> > http://www.signonsandiego.com/uniontrib/20040902/news_1b2oracle.html
>
> Likely but not necessesarily. A table will show up in all_tables if
> you have been granted any privilege. So it could be there because you
> have been granted insert: Which does not mean you could ever select.

D'Oh!

I've made that mistake before. Here, I was just wondering if there actually was a table named tab.

jg

--
@home.com is bogus.
"Over 500 IT Professionals have not requested a look at JS Tuner." -
Dan Hotka