Oracle PL-SQL Interview Question:

State the difference between implict and explict cursors?

Submitted by: Administrator

Implicit Cursor are declared and used by the oracle internally. whereas the explicit cursors are declared and used by the user. more over implicitly cursors are no need to declare oracle creates and process and closes autometically. the explicit cursor should be declared and closed by the user.

Implicit cursors are used for single row query whereas explicit cursor is used for multiple row query
Submitted by: Administrator