17,140
社区成员




create or replace function new_split (str in varchar2, delimiter in varchar2)....
select new_split(name,',') into split_dataset from a;
j := 1;
len := split_dataset.count;
while j <= len
loop
select name into rp_name from b where id=split_dataset(j);
j := j+1;
v_sql := v_sql||rp_name;
end loop;
DBMS_OUTPUT.put_line(v_sql);