| René Nyffenegger's collection of things on the web | |
|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
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.
|