Monday, April 16, 2007

Oracle Implict and Explict Cursors

The difference between implict and explict cursors:

Implicit Cursor are declared and used by the oracle internally. Moreover implicitly cursors are no need to declare. Oracle creates and process and closes automatically.

Explicit cursors are declared and used by the user. Explicit cursor should be declared and closed by the user. Moreover Explicit Cursors were used to retrieve values from two or more rows.

No comments: