Oracle PL-SQL Interview Question:

Explain the two type of Cursors?

Submitted by: Administrator

There are two types of cursors, Implicit Cursor and Explicit Cursor.
PL/SQL uses Implicit Cursors for queries. User defined cursors are called Explicit Cursors. They can be declared and used.
Submitted by: Administrator

cursor-->1>implicit
--->2>explicit

implicit-->provided by oracle (when dml statements are executed , there are some attributes to check status of cursor eg. %found,%notfound,%rowcount,%isopen )
explicit -->user defined(user defined, syntax-->
cursor cursor_name is select statement)
Submitted by: Bhaskar Choudhary