SET SERVEROUTPUT ON; DECLARE v_fname students.first_name%TYPE; -- we declare an identical variable with the name v_fname and the identical type of first_name column from student BEGIN SELECT first_name INTO v_fname FROM students WHERE stu_id = 1; DBMS_OUTPUT.PUT_LINE(v_fname); END;