Re: Can I make oracle case sensitive

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Sat, 11 Sep 1999 01:12:24 +1000
Message-ID: <7rb9ak$1gc$1@m2.c2.telstra-mm.net.au>

Not like that, no. AFAIK.

But if you write your SQL using rabbit's ears (") around the table and column names, they better be in uppercase or nothing done!

Ie, using your example:
select * from "Customers" wouldn't work if the table is called CUSTOMERS. This is the syntax used to give tables and columns names that use funny characters. With the "blah" construct, ORACLE takes the blah thing verbatim. Rather than automatically converting it to u-case.

If I missed something here, please correct me now.

--
Cheers
Nuno Souto
nsouto_at_nsw.bigpond.net.au.nospam
Is there a nospam domain?
http://www.users.bigpond.net.au/the_Den Brant Remenda <Brant.Remenda_at_PelicanForge.com> wrote in message news:h79C3.1144$Ctq.25559171_at_tomcat.sk.sympatico.ca...
> 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 Fri Sep 10 1999 - 10:12:24 CDT