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

Get Oracle Database 10g Express Edition PHP Web Programming 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.