Explain What is a cursor? Why do you need them? What are the different kinds of cursor?

Submitted by: Administrator
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.
Submitted by: Administrator

Read Online Database Administration Job Interview Questions And Answers