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!

Need proper sorting for 1b and 10b in order by close

395285Aug 7 2003 — edited Mar 19 2008

Dear friends
i have a column which has data like this

pos
---
1b
10b

when i select this column and make an order by i get the data in following order

Pos
---
10b
1b

Techically this is right but logically not. i wan them to come in following way when i apply order by

Pos
---
1b
10b

Please advise

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 5 2003

Added on Aug 7 2003

2 comments

212 views