Re: select statement

[Quoted] 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

--
_______________________________________________________________________

[Quoted]   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
_______________________________________________________________________