Use "ALTER SESSION SET NLS_SORT = ...." to set the linguistic sorting order. By default it is set to BINARY which colates the digits before the alpha characters.

You can use "ALTER SESSION SET NLS_SORT = WEST_EUROPEAN" (as an example) to get alpha characters listed before the numeric characters.