ORACLE字符处理

Question

有下面一个表 TAB
NAME
,1,3434,455,65,
,22,33333,444,666,
,3434,34545,34545,我想取NAME字段的第二个数字, 也就是
3434
33333
34545怎么实现这个呢

Answer 1

SELECT substr(ltrim(name,','),1,indexof(substr(indexof(ltrim(name,','),',')+1,ltrim(name,',')),',')) from tab

Answer 2

try it ..
SQL> select ',1,3434,455,65,' from dual;',1,3434,455,65,'
-----------------
,1,3434,455,65,SQL> select substr(',1,3434,455,65,',instr(',1,3434,455,65,',',',1,2)+1,instr(',1,3434,455,65,',',',1,3)-instr(',1,3434,455,65,',',',1,2)-1) from dual;SUBSTR(',1,3434,455,65,',INSTR
------------------------------
3434

Answer 3

THANKS   mantisXF HTTP://WWW.1JU.ORG