1.

What Are Different Types Of Cursors?

Answer»

There are following two TYPES of cursors:

  •  Implicit cursor —Created by Oracle for-each individual SQL. If you use an implicit cursor, Oracle performs the OPEN, fetch, and CLOSE operations automatically.
  •  Explicit cursor —Used to fetch and manipulate multiple rows. As the name suggests, explicit cursor is specified explicitly. It is DECLARED, opened, fetched, and closed specifically. It is used with loop structures.

There are following two types of cursors:


Discussion

No Comment Found

Related InterviewSolutions