Basic HTML version of Foils prepared 7 October 97

Foil 30 Cursors in PL/SQL - I

From untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng, C.W. Ou, Geoffrey C. Fox


1 A cursor is a handle to or name for a specific private SQL area.
  • such an area is also called a private SQL area.
2 In application development, a cursor is a named resource available to a program, which can be specifically used for parsing SQL statements embedded with the application
3 PL/SQL implicitly declares a cursor for all SQL DML statements, including queries that return only one row
4 For queries that return more than one row, you must explicitly declare a cursor to process the rows individually

in Table To:


© 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