Re: case insentive

From: tiro <>
Date: Mon, 15 Sep 2008 19:29:12 +0200
Message-ID: <48ce9c49$0$40314$>

"Mark D Powell" <> ha scritto nel messaggio On Sep 15, 10:24 am, "gym dot scuba dot kennedy at gmail" <> wrote:
> "tiro" <> 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

Original text of this message