CREATE OR REPLACE FUNCTION get_C2(v_table_namevarchar2 , v_table_colvarchar2, v1 varchar2)
RETURN VARCHAR2
IS
Col_c2 VARCHAR2(4000);
BEGIN
FOR cur IN (SELECT v_table_colc2FROM fromv_tab_namewherev_table_col =v1) LOOP
Col_c2 := Col_c2||cur.c2;
END LOOP;
Col_c2 := rtrim(Col_c2,1);
RETURN Col_c2;
END;