SQL> select * from test_1;COL1 COL2 COL3 ---------- ---------- ---- A B 1000 A C 1100 A D 900 A E 400 B D 300 D F 600 E A 400 F G 1000 C B 600 1 1 11 行 已选择SQL> select substr(to_char(col3),1,instr(to_char(col3),'0',1)-1) as sub from test_1;SUB -------------------------------------------------------------------------------- 1 11 9 4 3 6 4 1 611 行 已选择
---------- ---------- ----
A B 1000
A C 1100
A D 900
A E 400
B D 300
D F 600
E A 400
F G 1000
C B 600
1
1 11 行 已选择SQL> select substr(to_char(col3),1,instr(to_char(col3),'0',1)-1) as sub from test_1;SUB
--------------------------------------------------------------------------------
1
11
9
4
3
6
4
1
611 行 已选择
http://www.netbox.cn/document/html/vsfctinstr.htm