Re: select statement
From: KFC <xegga_at_hotmail.com>
Date: Tue, 4 Jan 2000 22:49:10 +0800
Message-ID: <84t0sf$j6c3_at_imsp212.netvigator.com>
Date: Tue, 4 Jan 2000 22:49:10 +0800
Message-ID: <84t0sf$j6c3_at_imsp212.netvigator.com>
Since your table name is one of the keywords used by Oracle. Therefore you must use quote to specify it is your object.
William Teo <sucheeha_at_singnet.com.sg> wrote in message
news:84eufm$7mv$1_at_coco.singnet.com.sg...
> 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
>
>
Received on Tue Jan 04 2000 - 15:49:10 CET