CHAPTER 6
PL/SQL
CRITICAL SKILLS
6.1 Define PL/SQL and Why We Use It
6.2 Describe the Basic PL/SQL Program Structure
6.3 Define PL/SQL Data Types
6.4 Write PL/SQL Programs in SQL*Plus
6.5 Handle Error Conditions in PL/SQL
6.6 Include Conditions in Your Programs
6.7 Create Stored Procedures—How and Why
6.8 Create and Use Functions
6.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 be ...
Get Oracle Database 10g: A Beginner's Guide 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.
