hi
yes, it is possible. you can do it like this.

SELECT * FROM test
ORDER BY NLSSORT(name, 'NLS_SORT = XDanish');


----- Original Message -----
From: "Sridhar Ravikumar " <oracledba-ezmlmshield-x49418462.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, September 20, 2007 5:12 PM
Subject: Oracle 10G case insensitive... Using NLS_SORT=BINARY


>
> Hi All
>
> We can make case insensitive search and sort by setting environmental
> variables like
> SQL> alter session set NLS_SORT=BINARY_CI;
> Session altered.
> SQL> alter session set NLS_COMP=LINGUISTIC;
> Session altered.
>
> This is at Session level..
> Is it possible to make these setting at transactional level like for
> only few SQLs
>
> Thank you
> Regards
> Ravi
>
> ----------------------------------------------------------------------
> CONFIDENTIALITY NOTICE This message and any included attachments are from Cerner Corporation and are intended only for the addressee. The information contained in this message is confidential and may constitute inside or non-public information under international, federal, or state securities laws. Unauthorized forwarding, printing, copying, distribution, or use of such information is strictly prohibited and may be unlawful. If you are not the addressee, please promptly delete this message and notify the sender of the delivery error by e-mail or you may call Cerner's corporate offices in Kansas City, Missouri, U.S.A at (+1) (816)221-1024.
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
Oracle LazyDBA home page