René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

nlssort [Oracle SQL]

nlssort (string)
nlssort (string, nls-param)   
The nlssort function allows to choose any linguistic sort order for an order by clause in a select statement.
select foo from bar
 order by 
   NLSSORT(foo, 'NLS_SORT=FRENCH');
The behaviour of nls_sort can be influenced by setting the NLS_SORT, NLS_LANG, NLS_LANGUAGE NLS-parameters.