Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle is only case sensitive ?????

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

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Mon, 17 Feb 2003 08:53:07 -0800
Message-ID: <3E511373.B4876221@exesolutions.com> 





Mauro wrote:



> Is Oracle 8i only Case-Sensitive??

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

> case insensitive.

>

> thanks

> Mauro




Only case sensitive. To make string comparsions that are not case sensitive:



WHERE UPPER(column_name) = UPPER(column_name or some_value);



For indexes look up 'function based indexes' at http://tahiti.oracle.com.



Daniel Morgan
Received on Mon Feb 17 2003 - 10:53:07 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US