How to concatenate many rows to be one row?

[Cookies]

use a procedure with a cursor.

set serveroutput on;

DECLARE
v_string_new varchar2(200);

cursor cGet_String is
select column_A
from table_A;
-- use a where clause here to limit the return

BEGIN

v_string_new := '';

FOR v_string IN cGet_String LOOP

v_string_new := v_string_new || v_string.column_A;

END LOOP;

-- use an insert statement here to throw in a table if you like

dbms_output.put_line (v_string_new);

END;
/