FOR ID

Hi,

Which version of Oracle are you using...

I am getting the result u want from simple order by clause.

SQL>select * from test_db
2 order by 1;
A
----------
11a
1a2
21a
aaa
ana
bbb
bis
ccc
raul

9 rows selected.

Take Care.