- 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]