O'Reilly logo

Expert Oracle PL/SQL by Michael McLaughlin, Ron Hardman

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 2. PL/SQL Internals

How does this work?! This is our number one question whenever we use any complex tool. Although each of the other chapters in this book answers this question for the features being covered, none answers the question for PL/SQL as a whole. That's the purpose of this chapter.

In this chapter, we discuss PL/SQL architecture, including

  • Database architecture review

  • The PL/SQL compiler, including a discussion of Diana

  • Interpreted vs. native compilation

A Database Architecture Primer

There's no way to fully understand PL/SQL architecture without a basic awareness of the database architecture and its role in processing user requests. In this section, we review the database components used with PL/SQL, including the instance, 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