Re: Case sensitive

From: Murali <oraclems_at_hotmail.com>
Date: 19 Apr 2002 09:02:37 -0700
Message-ID: <22e6597b.0204190802.19054bc6@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 - 11:02:37 CDT