CHAPTER 29An Introduction to PL/SQL
PL/SQL is Oracle’s procedural language (PL) superset of the Structured Query Language (SQL). You can use PL/SQL to do such things as codify your business rules through the creation of stored procedures and packages, trigger database events to occur, and add programming logic to the execution of SQL commands.
The steps involved in the creation of triggers, stored procedures, and packages are described in the following chapters in this part of this book. In this chapter, you will see the basic structures and syntax used in PL/SQL.
PL/SQL Overview
PL/SQL code is grouped into structures called blocks. If you create a stored procedure or package, you give the block of PL/SQL code a name; if the block of PL/SQL code ...
Get Oracle Database 10g The Complete Reference 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.
