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

CRITICAL SKILL 6.1

Define PL/SQL and Why We Use It

The Oracle Database 10g is more than just a database. It is also an engine for many programming languages. Not only does it serve as a Java engine with the built-in Java Virtual Machine (JVM), it’s a PL/SQL engine as well. This means that the code you write may be stored in the database and then run as required.

The PL/SQL engine is bundled together with the database, and is an integral part of Oracle’s database, providing you with a powerful language to empower your logic and data. Let’s look at how PL/SQL fits into the Oracle database. Figure 6-1 shows you how PL/SQL works from with in, and from outside, the database.

FIGURE 6-1. The PL/SQL architecture

At the center of the Oracle Database ...

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