Re: select statement

Results output from sql*plus as follows:

create table 'test' (a number(15))

             *
ERROR at line 1:
ORA-00903: invalid table name

Yves Wetzels <yves.wetzels_at_virgajesse.be> wrote in message news:3871BED4.E349A47A_at_virgajesse.be...
> Hi William,
>
> I do not know Oracle 8i Enterprise but
> is it possible you created a table with quotes ?
> Something like
>
> create table "test" ...
>
> instead of
>
> create table test ...
>
>
> What does USER_TABLES tell you ?
>
> hope this helps
> yves.
>
>
> William Teo wrote:
>
> > Hi,
> >
> > I have created a table on the Oracle 8i Enterprise, the strange thing(to
me)
> > is that when I issue a select * from table_name; I got the error
message
> > that the table does not exits. However, when I try select * from
> > "table_name"; I got my result.
> >
> > Could anyone explain the above phenomenon.
> >
> > thanks
> > William
>
>
>
> --
> _______________________________________________________________________
>
> Yves Wetzels E-mail yves.wetzels_at_virgajesse.be
> IT-Department Phone +32-11-30.83.27
> Virga Jesseziekenhuis
> Stadsomvaart 11 Fax +32-11-30.82.38
> B-3500 HASSELT
> Belgium
> _______________________________________________________________________
>
>
Received on Wed Jan 05 2000 - 05:54:54 CET