Skip to content

Instantly share code, notes, and snippets.

@aaguilera

aaguilera/linguistic_sort_sample.sql

Created June 30, 2020 06:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save aaguilera/a0f16f533b0d89af45c344af7d8563cc to your computer and use it in GitHub Desktop.
Save aaguilera/a0f16f533b0d89af45c344af7d8563cc to your computer and use it in GitHub Desktop.
Download ZIP
Linguistic sort with Oracle
Raw
linguistic_sort_sample.sql
--
-- Sort using catalan rules
--
SELECT *
FROM software
ORDER BY NLSSORT(nom, 'NLS_SORT=catalan');
@aaguilera
Copy link
Author

Reference: Linguistic Sorting and String Searching

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment