Part IV. SQL in PL/SQL

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, 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), which was introduced in Oracle8i Database.

Chapter 14, DML and Transaction Management

Chapter 15, Data Retrieval

Chapter 16, Dynamic SQL and Dynamic PL/SQL

Get Oracle PL/SQL Programming, 4th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.