5.1 Define PL/SQL and Learn Why We Use It

5.2 Describe the Basic PL/SQL Program Structure

5.3 Define PL/SQL Data Types

5.4 Write PL/SQL Programs in SQL*Plus

5.5 Handle Error Conditions in PL/SQL

5.6 Include Conditions in Your Programs

5.7 Create Stored Procedures—How and Why

5.8 Create and Use Functions

5.9 Call PL/SQL Programs

The basic way we access data with Oracle is via SQL. It provides us with the ability to manage both the database and the information. However, you generally will find that SQL cannot do everything that the programmer needs to do. SQL has an inherent lack of procedural control of the output; it has no array handling, looping constructs, and other programming language features. PL/SQL can ...

Get Oracle Database 11g A Beginner's Guide now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.