O'Reilly logo

Oracle Database 10g: A Beginner's Guide by Michael Corey, Michael Abbey, Ian Abramson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required