Re: select in oracle

Hi,

Anything enclosed by double quotes is treated as case-sensitive. All else is uppercase.

Maarten

"Jérôme PERRET" <jperret_at_freesurf.fr> wrote in message news:93em53$kuo$1_at_wanadoo.fr...
> Your are right, I tried to create a table "Dummy" and it became case
> sensitive. But when you create a table Dummy, it is not.
> But when I create the table "Dummy", i can NOT perform a select, drop or
> anything elese without using double quote. Why ?
>
> SQL> CREATE TABLE "Dummy" (id number(8));
> Table created.
> SQL> DROP TABLE DUMMY;
> DROP TABLE DUMMY
> *
> ERROR at line 1:
> ORA-00942: table or view does not exist
> SQL> DROP TABLE Dummy;
> DROP TABLE Dummy
> *
> ERROR at line 1:
> ORA-00942: table or view does not exist
> SQL> Drop table "Dummy";
> Table dropped.
>
>
>
> SQL> CREATE TABLE Dummy (id number(8));
> Table created.
> SQL> DROP TABLE DUMMY;
> Table dropped.
> SQL>
>
>
> <maarten.scharroo_at_wkap.nl> a écrit dans le message :
> 93ehnu$sql$1_at_nereid.worldonline.nl...
> > 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 - 14:28:26 CET