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;