sangeeta

• Jun 1st, 2005

 

oracle uses private sql area to execute sql queries and store the information.pl/sql uses cursors to name these private sql area and access its stored information 
there r two types of cursors 
implicit 
explicit 
implicit cursors are used for all dml and single row queries.these are system defined 
explicit cursors are used for queries which return multiple row .these are user defined.

Shyam

• Dec 22nd, 2005

 

Hi,

Implicit cursors are system define where explicit cursor is user defined.

Implicit cursor return one row where explicit cursor return multiple rows.

Thanks,

Shyam

manish dudhe

• Oct 15th, 2007

 

implicit ,explicit,ref cursor