image

CHAPTER32An 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 the book. In this chapter, you will learn about the basic structures and syntax used in PL/SQL.

PL/SQL Overview

PL/SQL code is grouped into structures called blocks. If you ...

Get Oracle Database 12c 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.