In this chapter, you will learn about
• PL/SQL in client/server architecture
• PL/SQL in SQL*Plus
PL/SQL stands for Procedural Language Extension to SQL. PL/SQL extends SQL by adding programming structures and subroutines available in any high-level language. In this chapter, you will see examples that illustrate the syntax and rules of the language.
PL/SQL is used for both server-side and client-side development. For example, database triggers (code that is attached to tables, as discussed in Chapter 13, “Triggers”) on the server side and logic behind an Oracle Developer tool on the client side can be written using PL/SQL. In addition, PL/SQL can be used to develop applications for browsers such ...