By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select * from V$VERSION;
| BANNER | BANNER_FULL | BANNER_LEGACY | CON_ID |
|---|---|---|---|
| Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production | Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production Version 21.3.0.0.0 |
Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production | 0 |
create table t(val varchar2(100))
insert into t
select 'AD4' from dual union all
select 'aA1' from dual union all
select 'äB2' from dual union all
select 'aC3' from dual union all
select '1' from dual union all
select '2' from dual union all
select 'XAA2' from dual union all
select 'X1A1' from dual
8 rows affected
select val
from t
order by val
| VAL |
|---|
| 1 |
| 2 |
| AD4 |
| X1A1 |
| XAA2 |
| aA1 |
| aC3 |
| äB2 |
select val
from t
order by val COLLATE XGERMAN_AI
| VAL |
|---|
| aA1 |
| äB2 |
| aC3 |
| AD4 |
| XAA2 |
| X1A1 |
| 1 |
| 2 |
select val
from t
order by nlssort(val, 'NLS_SORT=GENERIC_M_AI')
| VAL |
|---|
| 1 |
| 2 |
| aA1 |
| äB2 |
| aC3 |
| AD4 |
| X1A1 |
| XAA2 |
select val
from t
order by val COLLATE GENERIC_M_AI
| VAL |
|---|
| 1 |
| 2 |
| aA1 |
| äB2 |
| aC3 |
| AD4 |
| X1A1 |
| XAA2 |
select val
from t
order by val COLLATE UCA0620_DUCET_AI
| VAL |
|---|
| 1 |
| 2 |
| aA1 |
| äB2 |
| aC3 |
| AD4 |
| X1A1 |
| XAA2 |