Re: How configure Oracle 9i not case sensitive...

From: Douglas Hawthorne <douglashawthorne_at_yahoo.com.au>
Date: Fri, 23 Apr 2004 11:00:35 GMT
Message-ID: <nH6ic.26234$V_3.15459@news-server.bigpond.net.au>

"Eloy Mier Pérez" <eloy.mier_at_tantacom.com> wrote in message news:Ku5ic.115120$Rc.3299230_at_news-reader.eresmas.com...
> Hi, i would configure Oracle 9i not case sensitive and in the table names
> dont use ""...
>
> How can i do this ?
>
> Thanks in advance
>
>

Eloy,

By default, names in Oracle are stored in upper case. To get mixed case, you will have to enclose the name in double quotes.

The following example demonstrates this: SQL> CREATE TABLE "Mixed_Case" AS SELECT * FROM emp;

Table created.

SQL> SELECT table_name FROM user_tables;

TABLE_NAME

---

DEPT
EMP
EMP_DEPT
Mixed_Case
PLAN_TABLE Douglas Hawthorne Received on Fri Apr 23 2004 - 06:00:35 CDT