Re: nls_sort=binary_ci

janu wrote:
> Here is the query
>
> SELECT ACTION_ID
> , ACTION_NAME
> ,pd_id
> , PD_NAME
> , PT_NAME
> , PD_GLOBAL_JOIN.GP_VALUE
> , PD_GLOBAL_JOIN.GP_NAME
> , AV_VALUE
> , AV_GLOBAL_JOIN.GP_VALUE AV_GLOBAL_JOIN_GP_VALUE
> , AV_GLOBAL_JOIN.GP_NAME AV_GLOBAL_JOIN_GP_NAME
> , AV_GLOBAL_JOIN.GP_DESCRIPTION AV_GLOBAL_JOIN_GP_DESCRIPTION
> , AV_GLOBAL_JOIN.GP_PROJECTID AV_GLOBAL_JOIN_GP_PROJECTID
> , AV_GLOBALPARAMETERID
> FROM VMTP_ACTION
> LEFT JOIN VMTP_PARAMETERDEFINITION ON
> (ACTION_ID = PD_ACTIONID
> AND PD_METASTATUS = 1)
> LEFT JOIN VMTP_ACCEPTEDVALUE ON
> (PD_ID = AV_PARAMETERDEFINITIONID)
> LEFT JOIN VMTP_GLOBALPARAMETER AV_GLOBAL_JOIN ON
> (AV_GLOBALPARAMETERID = AV_GLOBAL_JOIN.GP_ID)
> LEFT JOIN VMTP_PARAMETERTYPE ON
> (PD_PARAMETERTYPEID = PT_ID)
> LEFT JOIN VMTP_GLOBALPARAMETER PD_GLOBAL_JOIN ON
> (PD_DEFAULT_GLOBALPARAMETERID = PD_GLOBAL_JOIN.GP_ID)
> WHERE ACTION_ID IN (166)
> order by pd_name;
>

Consider a syntax related to this:

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

-- 
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