Hi,
I've got a problem when I sort the results. Look this.
The original set was:
cc
aa
bb
11
33
22
And i want to sort this with the ascending ascii criteria:
11
22
33
aa
bb
cc
But Oracle return, doing an 'order by' this set:
aa
bb
cc
11
22
33
How can I solve this problem? Is there any way to
specify the ascii criteria in the 'order by' clause?
That is, i want something like:
'order by ascii(column)'
but not for only the first character; i want this for all
the characters of the field