Re: select statement
From: William Teo <sucheeha_at_singnet.com.sg>
Date: Thu, 30 Dec 1999 15:48:13 +0800
Message-ID: <84f2mn$bhi$1_at_coco.singnet.com.sg>
Date: Thu, 30 Dec 1999 15:48:13 +0800
Message-ID: <84f2mn$bhi$1_at_coco.singnet.com.sg>
Does (upper) impliy that I cap my table name?
If so, yes I did try but did not get the result.
William
Mike Tarrani <mtarrani_at_pacbell.net> wrote in message
news:386B0A01.AB176FFD_at_pacbell.net...
> Do you get expected results if you do a select * from (upper) table_name?
>
> 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
>
>
>
Received on Thu Dec 30 1999 - 08:48:13 CET