Types of PL/SQL Programs
Now that you understand the basics of the PL/SQL language, it's time to learn more about the different types of programs you can create with PL/SQL, including anonymous PL/SQL blocks, procedures, functions, packages, and database triggers.
Anonymous PL/SQL Blocks
The previous examples in this chapter are all anonymous PL/SQL blocks. An anonymous block is a PL/SQL block that appears within your application. An anonymous PL/SQL block has no name and is not stored in the database. The application simply sends the block of code to the database server for processing at run time.
Stored Procedures and Functions
Several exercises in this chapter taught you how to declare and use PL/SQL subprograms (procedures and functions) within ...
Get Hands-On Oracle Database 10g Express Edition for Windows 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.
