oracle xx.xxx.xxx排序

select st_order from sys_module order by decode(instr(st_order,'.',1,1), 0, st_order, substr(st_order, 1, instr(st_order,'.',1,1) - 1)), decode(instr(st_order,'.',1,2), 0, decode(instr(st_order,'.',1,1), 0, '00', substr(st_order, instr(st_order,'.',1,1) + 1)), substr(st_order, instr(st_order,'.',1,1) + 1, instr(st_order,'.',1,2) - instr(st_order,'.',1,1) - 1)), decode(instr(st_order,'.',1,3), 0, decode(instr(st_order,'.',1,2), 0, '00', substr(st_order, instr(st_order,'.',1,2) + 1)), substr(st_order, instr(st_order,'.',1,2) + 1, instr(st_order,'.',1,3) - instr(st_order,'.',1,2) - 1)), decode(instr(st_order,'.',1,4), 0, decode(instr(st_order,'.',1,3), 0, '00', substr(st_order, instr(st_order,'.',1,3) + 1)), substr(st_order, instr(st_order,'.',1,3) + 1, instr(st_order,'.',1,4) - instr(st_order,'.',1,3) - 1))

 

 

1 1
2 1.1.1
3 1.1.1.1
4 1.1.1.2
5 1.1.1.3
6 1.1.1.4
7 1.1.2
8 1.1.2.1
9 1.1.2.2
10 1.1.3
11 1.11.1
12 11.0
13 2
14 2.1
15 2.1.1
16 2.1.2
17 2.1.3
18 2.1.4
19 2.1.5
20 3
21 3.1
22 3.1.1
23 3.1.2
24 3.1.3
25 3.1.4
26 3.1.4.1
27 3.1.4.2
28 3.1.4.3
29 3.2
30 3.2.1
31 3.2.2
32 3.2.3
33 3.2.4
34 3.2.5
35 3.2.5.1
36 3.2.5.2
37 3.2.6
38 3.2.7
39 3.2.7.1
40 3.2.7.2
41 3.2.7.3
42 3.2.7.4
43 3.2.7.5
44 3.2.7.6
45 3.2.7.7
46 3.2.7.8
47 3.2.7.9
48 3.3
49 3.3.1
50 3.3.2
51 3.3.3
52 3.4
53 3.5
54 3.5.1
55 3.5.2
56 3.5.3
57 3.5.4
58 3.6
59 3.6.1
60 3.6.2
61 3.6.3
62 3.6.3.1
63 3.6.3.2
64 3.6.3.3
65 3.7
66 3.7.1
67 3.7.2
68 3.7.3
69 3.8
70 4
71 4.1
72 4.2
73 4.2.1
74 4.2.2
75 4.2.3
76 4.3
77 4.4
78 5
79 5.1
80 5.2
81 5.2.1
82 5.3
83 5.3.1
84 5.4
85 5.5
86 5.5.1
87 5.6
88 5.6.1
89 6
90 6.1.1
91 6.1.2
92 6.1.3
93 6.1.4
94 6.1.5
95 6.1.6
96 6.1.7
97 6.1.8