begin
for i in 1..ceil(length(SWJGDM)/255) loop
if i=1 then
dbms_output.put_line(substr(SWJGDM,1,i*255));
else
dbms_output.put_line(substr(SWJGDM,(i-1)*255,i*255));
end if;
end loop;
end;
转载于:https://www.cnblogs.com/xtzhilv/archive/2012/05/19/2508984.html