4.1.15. PL Cursors

  • DECLARE
  • name_attr EMPLOYEE.NAME%TYPE;
  • ssn_attr EMPLOYEE.SSN%TYPE;
  • /* cursor declaration */
  • CURSOR myEmployeeCursor IS
    • SELECT NAME,SSN FROM EMPLOYEE
    • WHERE DNO=1
    • FOR UPDATE;
  • emp_tuple myEmployeeCursor%ROWTYPE;