Chapter 14. The Basics of PL/SQL
PL/SQL (Procedure Language SQL) is Oracle’s programming language and is a powerful programming tool. It is comparable to COBOL, Fortran, C, or Java. PL/SQL is used to tell the Oracle database how to process records. It is also used in Oracle’s development tools. Just as Visual Basic is the power behind Microsoft’s Visual Basic, PL/SQL is the power behind Oracle Forms and Reports. The language is used to define a form’s behavior, to perform special calculations in a report, and to process records.
As with COBOL, PL/SQL allows the developer to define local variables, cursors, IF-THEN-ELSE constructs, and several different types of looping procedures. Cursors allow the developer to process records one at a time. ...
Get Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts 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.
