The central purpose of the Oracle PL/SQL language is to make it as easy and efficient as possible to query and change the contents of tables in a database. You must use the SQL language to access tables, and each time you do so, you use a cursor to execute your task.
:What is a cursor?
- is a pointer to a private SQL area that stores information about the processing of a SELECT or
- (DML)data manipulation language statement (INSERT, UPDATE, DELETE, or MERGE).
Cursor management of DML statements is handled by Oracle Database,
but PL/SQL offers several ways to define and manipulate cursors to execute SELECT statements.