SET serveroutput ON
SET verify OFF
DECLARE
rec2 emp%rowtype;
BEGIN
SELECT * INTO rec2 FROM EMP WHERE employee_id = 100;
dbms_output.put_line(REC2.employee_id || ' ' || REC2.first_name );
END;
/
SET verify ON
SET serveroutput ON
SET verify OFF
DECLARE
type rec_type
IS
RECORD
(
employee_id NUMBER,
first_name VARCHAR2(20) );
rec2 rec_type;
BEGIN
SELECT employee_id,first_name INTO rec2 FROM EMP WHERE employee_id = 100;
dbms_output.put_line(REC2.employee_id || ' ' || REC2.first_name );
END;
/
SET verify ON