Live ORACLE

DECLARE

  dept_info  departments%ROWTYPE;

BEGIN

  -- department_id, department_name, and location_id are the table columns

  -- The record picks up these names from the %ROWTYPE.

  dept_info.department_id := 300;

 

  dept_info.department_name := 'Personnel';

 

  dept_info.location_id := 1700;

 

  -- The fields of a %ROWTYPE can completely replace the table columns

  -- The row will have values for the filled-in columns, and null

  -- for any other columns

  UPDATE departments

  SET    ROW = dept_info

  WHERE  department_id = 300;

END;

/

Updating a Row Using a Record