sasfvs

Untitled

Jul 5th, 2017
259
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.28 KB | None | 0 0
  1. SET SERVEROUTPUT ON;
  2. DECLARE
  3.     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
  4. BEGIN
  5.     SELECT first_name INTO v_fname FROM students WHERE stu_id = 1;
  6.     DBMS_OUTPUT.PUT_LINE(v_fname);
  7. END;
Advertisement