Re: Oracle Sql-plus question

awdorrin_at_kocrsv01.delcoelect.com (Albert W. Dorrington) wrote:

> I thought I had figured this out once before, but I can't
>seem to remember right now.
> Is there a way using an sqlplus query to have an order by
>clause actually order the numbers in numeric order,
>(1, 2, ... 10, 19, 20, etc) instead of its strange ordering
>(1, 10, 19, 2, 20, etc)
 

> Thanks in advance,
> Al
 

>--
>Al Dorrington
>awdorrin_at_ictest.delcoelect.com Database Admin
>Delco Electronics - IC CIM Unix Sysadmin
>Kokomo, Indiana, USA Phone: 317.451.9655

It looks like your "numbers are actually character type.

Try Select To_Number(column_name) from table_name;

Michael Tharp

St. Paul, Minnesota USA
mtharp_at_minn.net Received on Thu Dec 07 1995 - 00:00:00 CET