Relative Content

Tag Archive for sqldatabaseoraclesortingsql-order-by

How to sort numbers before letters with linguistic sorting?

In an Oracle SQL query which uses binary sorting rules, numbers are sorted before letters. But if the query uses a language specific collation to enable linguistic sorting, then numbers are sorted after letters.
Example: https://dbfiddle.uk/BBfvb2lh