| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> [Help] How to sort like this with SQL?
I have the table with one column and it has
some datas like this:
1
If I select this with later statement you can
get this result:
SELECT Work_Item
1
But I want to sort this datas like this:
1
Good Luck to all the people who read this!
1.1
1.10
1.2
1.5
1.11
1.3
1.4
1.12
...
FROM Work_Table
ORDER BY Work_Item;
1.1
1.10
1.11
1.12
1.2
1.3
1.4
1.5
...
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'm using Oracle 7.0 with SQL*Plus 3.1.
Thanks in advance. Received on Sun Jan 21 1996 - 21:03:31 CST
 |
 |