Re: select in oracle

[Quoted] 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 - 10:37:01 CET