Live ORACLE

DECLARE

  dept_rec1  departments%ROWTYPE;

   dept_rec2  departments%ROWTYPE;

   CURSOR c1 IS

     SELECT department_id,

            location_id

     FROM   departments;

   dept_rec3  c1%ROWTYPE;

BEGIN

  dept_rec1 := dept_rec2; -- allowed



-- dept_rec2 refers to a table, dept_rec3 refers to a cursor

-- dept_rec2 := dept_rec3; –– not allowed

END;

/

Assigning Values to a Record With a %ROWTYPE Declaration