Re: Can I make oracle case sensitive

    After reading the responses, I experimented with making table and column names case insensitive.

    Not only could be they be case insensitive but one could add rather strange characters to the names.

    For example,

SQL> create table "My Special Table" (
  2 "34 &^%$" varchar2(1),
  3 "new line
  4 here" varchar2(1))
  5 ;

Table created.

SQL> desc "My Special Table"

 Name                                                  Null?    Type
 ----------------------------------------------------- -------- -----------
 34 &^%$                                                        VARCHAR2(1)
 new line
here                                                  VARCHAR2(1)

    Everything seems to work except exporting or importing the table explicitly with using a tables=("My Special Table"). An export at the user level, however, succeeded.

    Is there a way to make the export work at the table level?

    Frank Hubeny
    Wheaton, IL

Brant Remenda wrote:

> Is it possible to make Oracle case sensitive. I am using Oracle 8 and would
> like to make it case sensitive so that an SQL statement such as:
> Select * from Customers
> would not work if the Customers table is spelled CUSTOMERS
>
> I would also like to make columns case sensitive.
>
> Thanks in advance
> Brant
Received on Sat Sep 11 1999 - 20:52:41 CDT