Chapter 8, Problem 16RQ

Program Plan Intro

PL/SQL:

• In Oracle, the stored procedures can be created using a language called PL/SQL.
• The procedures are created and saved as the script files.
• SQL is used to perform the DML and DDL operations using the single query.
• Whereas the PL/SQL uses a block of codes to write the entire program in terms of blocks or procedures or functions.

Cursor:

Cursor is used to retrieve information in row by row fashion. If the records stored in the database table needs to update one row at a time, then this is carried out by the cursor.