Re: select in oracle

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 9 Jan 2001 06:41:58 +0100
Message-ID: <93eg1n$9rtmd$3@ID-62141.news.dfncis.de>

Comments embedded
Hth,

Sybrand Bakker

"tim leung" <m_010_at_yahoo.com> wrote in message news:3a5b75bd.17490718_at_enews.newsguy.com...
> Hi,
> I have an oracle table like the following:
>
> SQL> describe platform;
> Name Null? Type
> --------------------------------------------
> PLATFORMID NUMBER(1)
> NAME VARCHAR2(128)
> DESCRIPTION VARCHAR2(255)
>
>
> But when I try to get a simple select statement. I get an erorr:
>
> SQL> select * from platform where name = Win32;
> Input truncated to 1 characters
> select * from platform where name = Win32
> *
> ERROR at line 1:
> ORA-00904: invalid column name
>
> I need a single quote:
> SQL> select * from platform where name = 'WIN32';
>
> Is that I must use a single quote?

Yeah, sure, as in *all* databases. Check the syntax before you start posting.

Is that oracle on NT is not case
> sensitive?

and on not on Sun, on HP-UX, on RS/6000, on Linux, and *all* other platforms.

Since I can use upper and lower case for table name.
> Thanks.
>
Received on Mon Jan 08 2001 - 23:41:58 CST