Basic HTML version of Foils prepared 7 October 97

Foil 31 Cursors in PL/SQL - II

From untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng, C.W. Ou, Geoffrey C. Fox
You can use a cursor to re-execute SQL statements - after each stage of execution, the cursor retains enough information about the statement to re-execute it without starting over again
Cursors are "structured" in that know about SQL -- you can open, close and fetch from a cursor
  • Fetch gets get row from results table -- called a cursor as moves through table
Closing a cursor means the information currently in the associated private area is lost and its memory is deallocated

© Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Thu Feb 5 1998