I think what is usually meant is that the user thinks that
select enam,sal,mgr from emp where ename like 'HOWARD'
should be the same as
select enam,sal,mgr from emp where ename like 'HoWAarD'
In otherwords the 'problem' is not with object names but with literal
values. I personally think this is undesirable behaviour but maybe I've been
brainwashed.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
(actually in my case the above queries are the same "No rows selected" )
"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
news:a9ot59$ikp$1_at_lust.ihug.co.nz...
> I've never quite worked out what 'case insensitive' means.
> You'll find that, in Oracle, if you do a 'select * from EMP' or a 'SeLeCt
*
> FrOm EmP', it's all the same to Oracle... you'll get the same results
every
> time, which surely means that Oracle is case insensitive out of the box.
>
> Unless... unless.... you are daft enough to create your column names in
> specified case originally, in which case Oracle does the decent thing and
> respects the case you asked for.
>
> Hence: create table 'BlAh' (col1 char(4)) ... now requires you henceforth
to
> select * from 'BlAh' (use of quotes not optional). But that's only because
> you used the case-preserving quotes in the first place.
>
> Now it's unfortunate that converting from (say) Access to Oracle means all
> column names are case-sensitive. Is there something to switch that
behaviour
> off? Nope. Is that a reason for religiously making sure that all table and
> column names are upper case before converting? Yup. Do it all the time:
You
> have to, too.
>
> Regards
> HJR
>
>
>
> "Microsoft User" <berdii_at_techemail.com> wrote in message
> news:a9oor1$lrf$1_at_ail.sri.ucl.ac.be...
> > Hi,
> >
> > Somebody can tell me how to change case sensitive to case insensitive on
> an
> > installed Oracle 8i
> > under windows 2000
> >
> > Thank you
> >
> >
>
>
Received on Fri Apr 19 2002 - 06:19:54 CDT
