Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Order By Character Column
This seems to work (using the varchar :) definition of Mark's table) - although I am assuming that values like '......' and '1.1.1' aren't allowed
Cheers,
Ian
select * from sort_test;
A
select a
from sort_test
order by
decode(rtrim(translate(a,'0123456789.','00000000000'),'0'),null,to_number(a)),a;
A
For the latest data on the economy and society consult National Statistics at http://www.statistics.gov.uk
The original of this email was scanned for viruses by the Government Secure Intranet (GSi) virus scanning service supplied exclusively by Energis in partnership with MessageLabs.
On leaving the GSi this email was certified virus-free
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 29 2004 - 06:55:41 CDT
![]() |
![]() |