SET SERVEROUTPUT ON;
DECLARE
v_column VARCHAR2(100);
BEGIN
DBMS_OUTPUT.ENABLE;
INSERT INTO table1(column1) VALUES ('TEST VALUE') RETURNING column1 INTO v_column;
DBMS_OUTPUT.PUT_LINE(v_column);
END;
SET SERVEROUTPUT ON;
DECLARE
v_column VARCHAR2(100);
BEGIN
DBMS_OUTPUT.ENABLE;
INSERT INTO table1(column1) VALUES ('TEST VALUE') RETURNING column1 INTO v_column;
DBMS_OUTPUT.PUT_LINE(v_column);
END;