日期:2014-05-17 浏览次数:20934 次
create table t_clob (id number,str clob);
insert into t_clob values(1,'aaa'
------解决方案--------------------
chr(10)
------解决方案--------------------
'bbb'
------解决方案--------------------
chr(10)
------解决方案--------------------
'ccc');
insert into t_clob values(2,'111'
------解决方案--------------------
chr(10)
------解决方案--------------------
'222'
------解决方案--------------------
chr(10)
------解决方案--------------------
'333'
------解决方案--------------------
chr(10)
------解决方案--------------------
'444');
/
declare
v_amount BINARY_INTEGER := 4000;
v_offset INTEGER := 1;
v_buffer varchar2(4000);
BEGIN
for j in (select id, str
from (select id,
regexp_substr(str,
'[^'
------解决方案--------------------
chr(10)
------解决方案--------------------
']+',
1,
level) str,
level lv
from t_clob t
CONNECT BY id = PRIOR id
&n