Live ORACLE

DECLARE

  TYPE recordtyp IS RECORD(LAST employees.last_name%TYPE,

                            id employees.employee_id%TYPE);

   rec1  RECORDTYP;

BEGIN

  SELECT last_name,

         employee_id

  INTO   rec1

  FROM   employees

  WHERE  ROWNUM < 2;

 

  dbms_output.Put_line('Employee #'

                       ||rec1.id

                       ||' = '

                       ||rec1.LAST);

END;

/

Using SELECT INTO to Assign Values in a Record