janu wrote:
> Hi,
>
> I am having issues with nls_sort=binary_ci, nls_sort setting is not
> sorting rows in case insensitive
>
> Oracle 10g R2
> Linux x86
>
> steps I followed
>
> alter system set nls_sort=binary_ci scope=spfile;
> create pfile from spfile;
> shutdown immediate;
> startup open;
>
> Here is the sample data after the setting
>
> ACTION_ID ACTION_NAME PD_ID PD_NAME
>
> 166 Admin::AdminEditRole 773 SPrivileges
> 166 Admin::AdminEditRole 774 SPrivileges
> 166 Admin::AdminEditRole 775 sNewRoleName
> 166 Admin::AdminEditRole 775 sOriginalRoleName
>
>
> I WANT THE DATA TO BE SORTED LIKE THIS
>
> ACTION_ID ACTION_NAME PD_ID PD_NAME
>
> 166 Admin::AdminEditRole 775 sNewRoleName
> 166 Admin::AdminEditRole 775 sOriginalRoleName
> 166 Admin::AdminEditRole 774 SPrivileges
> 166 Admin::AdminEditRole 773 SPrivileges
>
>
>
> Thank you in advance
> RA
Changing an NLS_SORT parameter does not sort the data in a table.
Oracle's default tables are heap tables. Nothing is sorted.
What is the SQL statement you are issuing to retrieve the data?
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Nov 29 2006 - 17:02:36 CST
