CHAPTER6
Running PL/SQL from SQL
It is natural to think about running SQL from PL/SQL—after all, PL/SQL was created to provide a procedural language within (and alongside) the Oracle RDBMS, in order to be able to enhance SQL with all of the looping, logical, and exception-handling constructs of a traditional programming language. However, PL/SQL also allows you to extend the capabilities of SQL within Oracle. As a programmer, you are able to create your own functions that can be called from SQL, almost as if they are part of the SQL language. This allows you to extend the capabilities of SQL with all the benefits of PL/SQL. For example, you can ...
Get Real World SQL and PL/SQL: Advice from the Experts 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.
