Try this..
CREATE OR REPLACE PROCEDURE merge_two (p_table_name VARCHAR2)
AS
cursor c1 is select column_name FROM user_tab_cols WHERE table_name = p_table_name AND column_name = 'EMPNO';
var_col_1 VARCHAR2(100);
BEGIN
FOR x IN c1 LOOP
dbms_output.put_line(x.column_name);
END LOOP;
END;
/




Reply With Quote