Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET SERVEROUTPUT ON;
- DECLARE
- v_fname student.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;
Advertisement