DECLARE v_name varchar2(512); BEGIN FOR i in (select id from my_table GROUP BY id) LOOP v_name := NULL; FOR rec in (select name from my_table where id=i.id) LOOP v_name := v_name||rec.name; END LOOP; DBMS_OUTPUT.put_line(to_char(i.id)||' '||v_name); END LOOP; END; /
v_name varchar2(512);
BEGIN
FOR i in (select id from my_table GROUP BY id) LOOP
v_name := NULL;
FOR rec in (select name from my_table where id=i.id) LOOP
v_name := v_name||rec.name;
END LOOP;
DBMS_OUTPUT.put_line(to_char(i.id)||' '||v_name);
END LOOP;
END;
/