By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table t(val varchar2(100))
insert into t
select 'AD 6' from dual union all select 'aA 3' from dual union all select 'äB 4' from dual union all select 'aC 5' from dual union all select '1' from dual union all select '2' from dual union all select 'XAA 14' from dual union all select 'X1A 13' from dual union all select 'YssA 18' from dual union all select 'YsA 17' from dual union all select 'YßA 19' from dual union all select 'Y$A 15' from dual union all select 'YAA 16' from dual union all select 'YZA 20' from dual union all select 'SA 7' from dual union all select 'SB 8' from dual union all select 'SSB 11' from dual union all select 'ßB 10' from dual union all select 'TB 12' from dual union all select '$B 0' from dual union all select 'SC 9' from dual
21 rows affected
select val
from t
order by val COLLATE GENERIC_M_AI
| VAL |
|---|
| $B 0 |
| 1 |
| 2 |
| aA 3 |
| äB 4 |
| aC 5 |
| AD 6 |
| SA 7 |
| SB 8 |
| SC 9 |
| ßB 10 |
| SSB 11 |
| TB 12 |
| X1A 13 |
| XAA 14 |
| Y$A 15 |
| YAA 16 |
| YsA 17 |
| YssA 18 |
| YßA 19 |
| YZA 20 |