Re: Oracle is only case sensitive ?????

From: Hanne Iren Midttun <hannem_at_tihlde.org>
Date: Tue, 18 Feb 2003 10:18:09 +0100
Message-ID: <Pine.LNX.4.21.0302181015550.23767-100000@colargol.tihlde.org>

But, what is a password then?

eg: alter user system identified by bigBandA; sqlplus system/bigbanda

This works fine for me. (8.1.7.4 and AIX 4.3)

regards Hanne

--
Hanne Midttun
http://www.tihlde.org/~hannem

English is not my native tounge

On Mon, 17 Feb 2003, Niall Litchfield wrote:



> I suspect that the answers to what you are asking are respectively Yes and

> then No.

> 

> Oracle is case insensitive for identifiers i.e

> 

> select * from scott.emp; is the same as

> select * from SCOTT.emP;

> 

> but case sensitive for data, that is

> 

> 'McDonald'  is not the same as 'mcdonald'

> 

> 

> --

> Niall Litchfield

> Oracle DBA

> Audit Commission UK

> "Mauro" <benedetto_at_XXXXBluXP.com> wrote in message

> news:XY74a.16790$uA5.418938_at_tornado.fastwebnet.it...

> > Is Oracle 8i only Case-Sensitive??

> > Does not exist a parameter in database creation or installation for permit

> > case insensitive.

> >

> > thanks

> > Mauro

> >

> >

> 

> 

>

Received on Tue Feb 18 2003 - 03:18:09 CST