Question

oracle怎么用函数求一个存储过程的输入参数（是一个以，为分隔的字符串）的长度~！ 急，不胜感激！

Answer 1

select substr(',' || a.exc,
instr(',' || a.exc, ',', 1, b.rn) + 1,
instr(a.exc || ',', ',', 1, b.rn) -
instr(',' || a.exc, ',', 1, b.rn)) exc
from (select 'a,b,c,d,e,f,g,h' exc from dual t) A,
(SELECT ROWNUM RN FROM DUAL CONNECT BY ROWNUM < 20) B
where length(a.exc) - length(replace(a.exc, ',')) + 1 >= b.rn

Answer 2

[TEST@orcl] SQL>select length('a,b,d,a,d,f,g,h,j,j,k') from dual;

LENGTH('A,B,D,A,D,F,G,H,J,J,K')
-------------------------------
21

追问

我是想要写一个函数来实现，如果我想把这里面的元素一个一个取出来的话怎么取呢？