Question

Explain pl/sql cursors with example and also explain its type

Answer 1

A cursor  is pointer  to  context  area and  it  hold the information  for processing  the statement  .  in  PL /SQL  is  context  area  is controlled  by the  cursor  and   also hold  information  on  select   statement  and rows  of information accessed by the  it.  it has different types such  

• Cursor FOR Loop

• Cursor Variables

• SELECT-INTO