Re: Can I make oracle case sensitive

Just use quotes around your table/column names. You can check the Data dictionary later on and see that your tables/columns are stored differently.

On Fri, 10 Sep 1999 16:57:48 GMT, shmurphy_at_my-deja.com wrote:

>In article <h79C3.1144$Ctq.25559171_at_tomcat.sk.sympatico.ca>,
> "Brant Remenda" <Brant.Remenda_at_PelicanForge.com> 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
>>
>> Brant, it's usually better to ride a wave than swim against it. You're
>also much better off handling the data within your app. If, at the
>beginning of a modual (before any other code) you place "Option Compare
>Text" (just as you might "Option Explicit) then you'll be telling your
>VB SQL statement that you don't want to ignore the case. The default in
>VB is Option Binary which automatically compares by case.
>
>Just a another tip, try not to use NOT NULL in Oracle unless your
>project demands it. It better to test for conditions within your app
>than waiting for Oracle to give you a run-time error.
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email