This part of the book addresses a central element of PL/SQL code construction: the connection to the underlying Oracle database, which takes places through SQL (Structured Query Language). Chapters 14 through 16 show you how to define transactions that update, insert, merge, and delete tables in the database; query information from the database for processing in a PL/SQL program; and execute SQL statements dynamically, using native dynamic SQL (NDS).
|Chapter 14, DML and Transaction Management|
|Chapter 15, Data Retrieval|
|Chapter 16, Dynamic SQL and Dynamic PL/SQL|