SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sorting of column with alpha-numeric characters

65955Nov 5 2001

Hi,

Help me please!
When I use the order by clause in a select statement to make a
sorted list on a varchar2 alphanumeric column, why come earlier
the all alpha characters (A..Z,a..z) than the numeric characters
(0..9)?

for example:
-----------
Alabama
Boston
Zurich
aple
cola
window
11
111
21

Is it possible to set the Oracle to normal order sequence like
this?

-----------
11
111
21
Alabama
Boston
Zurich
aple
cola
window

Thanks
Viktor

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 4 2001

Added on Nov 5 2001

5 comments

474 views