Sort Numbers in PLSQL

Issue:

Solution:

Sort Numbers Only

ORDER BY REGEXP_REPLACE(<COLUMN_NAME>, '[[:digit:]]', '~') ASC;

Sort Numbers and Text

ORDER  BY REGEXP_REPLACE(<COLUMN_NAME>, '[[:digit:]]', '~') DESC, REGEXP_REPLACE(<COLUMN_NAME>, '[[:alpha:]]', '~') DESC;