Re: case insentive
From: tiro <tiro_at_mancino.it>
Date: Mon, 15 Sep 2008 19:29:12 +0200
Message-ID: <48ce9c49$0$40314$4fafbaef@reader5.news.tin.it>
Date: Mon, 15 Sep 2008 19:29:12 +0200
Message-ID: <48ce9c49$0$40314$4fafbaef@reader5.news.tin.it>
"Mark D Powell" <Mark.Powell_at_eds.com> ha scritto nel messaggio
news:d9c719e4-474f-4f0d-8257-7ccdafb64432_at_79g2000hsk.googlegroups.com...
On Sep 15, 10:24 am, "gym dot scuba dot kennedy at gmail"
<kenned..._at_verizon.net> wrote:
> "tiro" <t..._at_mancino.it> wrote in message
>
>Actually you can set a session parameter that will provide case
>insesitive searches and sorts in 10g onwards.
I tried the following statement
alter session set nls_comp=ansi
but it seems it doesn't success in oracle 11g What i did wrong? Received on Mon Sep 15 2008 - 12:29:12 CDT