How to sort all numbers before letters with linguistic sorting?...

MIN/MAX aggregate function with STRING in ORACLE...

regexp_replace() - maybe collation issue...

Oracle's puzzling behaviour with NLS_SORT and a simple REGEXP_LIKE()...

NLSSORT Oracle to Snowflake...

Why lowercase 'i' mapped to '?' after doing NLS_UPPER...

Change NLS_SORT for a single query...

Making Oracle sorting case-insensitive?...

How can I sort a table by a column for numeric letter first, then case sensitive for alphabet letter...

Oracle dynamic NLS_SORT with openjpa...