这个查询对我有用。

SELECT ( major 
     || '_' 
     || minor ) AS ver 
FROM   
(SELECT major, minor, 
    To_number(Replace(Decode(Substr(major, 0, 2), '1.',Substr(major, 3), major), '.', '')) 
      AS major_num, 
    To_number(Decode(Instr(minor, '-'), 0, minor,Substr(minor, 0, Instr(minor, '-') - 1))) 
      AS minor_num 
FROM   version) 
ORDER  BY major_num, 
      minor_num;

一种选择是提取所有数字片段（使用正则表达式；我认为这是最简单的选择 TO_NUMBER 并按这些值排序，例如。

SQL> with test (col) as
  2    (select '1.8.0' from dual union
  3     select '1.7.0' from dual union
  4     select '9.0'   from dual union
  5     select '10.0'  from dual
  6    )
  7  select col
  8  from test
  9  order by to_number(regexp_substr(col, '\d+', 1, 1)),
 10           to_number(regexp_substr(col, '\d+', 1, 2)),
 11           to_number(regexp_substr(col, '\d+', 1, 3));

COL
-----
1.7.0
1.8.0
9.0
10.0

SQL>

这里有一个黑客。。。

DROP TABLE IF EXISTS my_table;

CREATE TABLE my_table
(column1 VARCHAR(12) NOT NULL
,column2 DECIMAL(5,2) NULL
);

INSERT INTO my_table VALUES
('1.8.0',121),
('1.7.0',65),
('9.0',78),
('10.0',NULL);

SELECT a.column1
     , b.column2 
  FROM 
     (SELECT column1,@i:=@i+1 i FROM my_table,(SELECT @i:=0) vars ORDER BY INET_ATON(column1))a
  JOIN
     (SELECT column2,@j:=@j+1 j FROM my_table,(SELECT @j:=0) vars ORDER BY ISNULL(column2),column2)b
    ON b.j = a.i;
+---------+---------+
| column1 | column2 |
+---------+---------+
| 1.7.0   |   65.00 |
| 1.8.0   |   78.00 |
| 9.0     |  121.00 |
| 10.0    |    NULL |
+---------+---------+