4.1.16. Cursors execution

  • BEGIN
  • /* open cursor */
  • OPEN myEmployeeCursor;
  • /* can pull a tuple attributes into variables */
  • FETCH myEmployeeCursor INTO name_attr,ssn_attr;
  • /* or pull tuple into tuple variable */
  • FETCH myEmployeeCursor INTO emp_tuple;
  • CLOSE myEmployeeCursor;




  • [LOOP…END LOOP example on handout]