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

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

>

>