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