Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle can be Case Insensitive ?
You can use this UPPER function to make a view with only UPPERCASE
infomation and search with a query in UPPERCASE.... with the PK you
can find the correct row in the original table.......
So Oracle is not case insensitive but you an work around this with option like I just explaind...... :-)
On Thu, 4 Sep 2003 18:16:47 +0800, "Joe" <joe.yung_at_ecl-consulting.com> wrote:
>are you meaning the UPPER( ) function?
>
>something like
>select * from emp
>where upper(ename) = upper('scott');
>
>???
>
>
>
>
>
>
>"Roberto Leo" <roberto.leo_at_exm.it> wrote in message
>news:bj72dn$8l$1_at_newsread.albacom.net...
>> Oracle can be case insensitive ? What Options Should I set to be case
>> insensitive in the Oracle Database ?
>>
>> Thanks Rob.
>>
>>
>
Received on Thu Sep 04 2003 - 06:17:23 CDT