Re: Is Oracle is CASE SENSITIVE

From: Ling <circetsui_at_email.msn.com>
Date: Thu, 26 Oct 2000 20:21:29 -0400
Message-ID: <#i$e7v6PAHA.283@cpmsnbbsa07>

Yes, Oracle is case sensitive.

This applies to where the clause in your SQL.

Note that if you perform a create table statement like this

Create table TabA ( cola number(1) )

TabA will be created as TABA as it will be shown in the data dictionary, 'cause a object name will be converted to uppercase, unless you put the object name in quotes.

Regards,
Ling

"Bji" <bmahadev_at_hotmail.com> wrote in message news:bk1K5.143$UO3.5884_at_newsfeed.intelenet.net...
> Hello
> Is Oracle is case sensitive. If yes, i did not find anywhere in the oracle
> manual about this. Can any one tell me where to mention for the oracle to
do
> case in-sensitive search..
> Thanks in advance
> Bji
>
>
Received on Thu Oct 26 2000 - 19:21:29 CDT