NAME
----------
8-1-15-6
9-1-1-1
9-1-1-11
9-1-1-3
9-1-10-2
9-1-2-8
已选择6行。
已用时间: 00: 00: 00.70
SQL> select * from t order by to_number(substr(name,1,instr(name,'-')-1)),
2 to_number(substr(name,instr(name,'-')+1,instr(name,'-',1,2)-instr(name,'-')-1)),
3 to_number(substr(name,instr(name,'-',1,2)+1,instr(name,'-',1,3)-instr(name,'-',1,2)-1)),
4 to_number(substr(name,instr(name,'-',1,3)+1));
NAME
----------
8-1-15-6
9-1-1-1
9-1-1-3
9-1-1-11
9-1-2-8
9-1-10-2