Hi everyone,
what is the easiest way to sort these alphanumeric values so that A2 value comes before A11?
select * from (
select 'A11.1' from dual
union all
select 'A2' from dual
union all
select 'A2.1' from dual
union all
select 'P5' from dual
union all
select 'A11.1.2' from dual
union all
select '-A11.1.2d' from dual
)
order by 1
