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.