Live ORACLE

CREATE TABLE employees_temp
AS
SELECT employee_id,
      first_name,
      last_name
FROM   employees;



DECLARE

emp_id          employees_temp.employee_id%TYPE;

emp_first_name  employees_temp.first_name%TYPE;

emp_last_name   employees_temp.last_name%TYPE;

BEGIN

INSERT INTO employees_temp

VALUES     (299,

           'Bob',

           'Henry');



UPDATE employees_temp

SET    first_name = 'Robert'

WHERE  employee_id = 299;



DELETE FROM employees_temp

WHERE       employee_id = 299

RETURNING first_name,last_name INTO emp_first_name,emp_last_name;



COMMIT;



dbms_output.Put_line(emp_first_name

                    ||' '

                    ||emp_last_name);

END;

/

Robert Henry

PL/SQL procedure successfully completed.

Data Manipulation With PL/SQL