Taesoo,Cho wrote:
>
> ---------------------- Information from the mail header
> Sender: "ORACLE database mailing list." <ORACLE-L@SBCCVM.BITNET>
> Poster: "Taesoo,Cho" <yosemite_at_HITEL.KOL.CO.KR>
> Organization: KHRC
> Subject: [Help] How to sort like this with SQL?
>
>
> Good Luck to all the people who read this!
>
> I have the table with one column and it has
> some datas like this:
>
> 1
> 1.1
> 1.10
> 1.2
> 1.5
> 1.11
> 1.3
> 1.4
> 1.12
> ...
>
> If I select this with later statement you can
> get this result:
>
> SELECT Work_Item
> FROM Work_Table
> ORDER BY Work_Item;
>
> 1
> 1.1
> 1.10
> 1.11
> 1.12
> 1.2
> 1.3
> 1.4
> 1.5
> ...
>
> But I want to sort this datas like this:
>
> 1
> 1.1
> 1.2
> 1.3
> 1.4
> 1.5
> 1.10
> 1.11
> 1.12
> ...
>
> How can I get this result? Please be help!
> I believe this will order your work items sequentially
order by TO_NUMBER(TRANSLATE(Work_Item,'.','')) ASC,
however I am unable to test it do to rebuilding Designer/2000.
Wayne
GO GATORS !!
Received on Mon Jan 22 1996 - 00:25:01 CST
