Appendix I. PL/SQL Primer
The Procedure Language/Structured Query Language (PL/SQL) was developed by Oracle in the late 1980s. Originally, PL/SQL had limited capabilities, but that changed in the early 1990s. PL/SQL provides the Oracle database with an interpreted and operating system–independent programming environment. SQL is natively integrated in the PL/SQL language, and PL/SQL programs can be called directly from the command-line SQL*Plus interface covered in Appendix G. This appendix assumes you have basic familiarity with operating in the SQL*Plus environment, and that you will read it sequentially.
The PL/SQL language is a robust tool with many options. As a PL/SQL primer, the appendix introduces
Oracle PL/SQL block structure
Variables, ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access