While I’ve been out of the conference circuit the last few years, given the amount of work I’ve been doing brushing up on my PL/SQL knowledge, which will soon be featured in a series of blog posts, I figured I’d submit a session. Here it is:
CON1381 – Demystifying PL/SQL: The Life of a Compilation Unit
For almost 30 years, PL/SQL has evolved from a simple procedural language into an essential, advanced, and popular component of the Oracle Database. So popular, in fact, that PL/SQL is considered the defacto database procedural language, with other database vendors striving to imitate it. But, how does real PL/SQL work? How can you make the most of it? In this session, we’ll take an in-depth dive into the PL/SQL language from tokenization to parsing, preprocessing, compilation, optimization, debugging, and execution. After this session, you’ll have a solid understanding of not only what happens to your source code behind the scenes, but also why PL/SQL is such a powerful programming language.
In order to make sure the content is more widely understood, I’ll be translating complex theoretical and extremely low-level details into an intermediate-oriented session. Here’s to hoping it is accepted!