Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Case sensitive
True, true. I should have been more careful in how I phrased it. Thanks for
clarifying it.
Regards
HJR
"Murali" <oraclems_at_hotmail.com> wrote in message
news:22e6597b.0204190802.19054bc6_at_posting.google.com...
> "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.
> >
>
> It is the same result-wise (which is what this thread is about). But
> the statements dont mean the same to Oracle internally. They are
> parsed as 2 completely different statements in the librarycache.
>
> Murali
Received on Fri Apr 19 2002 - 13:30:22 CDT