select in oracle

From: tim leung <m_010_at_yahoo.com>
Date: Tue, 09 Jan 2001 02:22:13 GMT
Message-ID: <3a5c75ce.17508453_at_enews.newsguy.com>

Hi,
[Quoted] 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? Is that oracle on NT is not case sensitive? Since I can use upper and lower case for table name. Thanks. Received on Tue Jan 09 2001 - 03:22:13 CET