Re: select in oracle

[Quoted] Hi Jerome,

This is not completly true. Oracle-DDL is case-sensitive.

Try: CREATE TABLE "Dummy" (id number(8));

This will yield a table named: Dummy (NOT DUMMY).

To remove it you will have to use DROP TABLE "Dummy"; DROP TABLE DUMMY won't help.

The double quotes do the trick.

Maarten

"Jérôme PERRET" <jperret_at_freesurf.fr> wrote in message news:93ee05$8jk$1_at_wanadoo.fr...
>
> 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 - 09:20:03 CET