SQL to sort Number as char datatype

 

 Expected Output:

 

 

drop table t;

create table t(c number);

insert into t values(1);

insert into t values(2);

insert into t values(3);

insert into t values(11);

insert into t values(22);

insert into t values(33);

commit;

select c from t order by to_char(c);

select c from t order by cast(c as varchar2(100));

select c from t order by c||'';

select c from t order by substr(c,1,1),c;

select c from t order by ascii(c);