Re: select in oracle

[Quoted] tim leung <m_010_at_yahoo.com> a écrit dans le message : 3a5c75ce.17508453_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? Is that oracle on NT is not case
> sensitive? Since I can use upper and lower case for table name.
> Thanks.
>
you MUST use single quote for CHAR or VARCHAR2 values. I think your string is case sensitive but I am sure table and column names are NOT.

Jerome Received on Tue Jan 09 2001 - 08:17:51 CET