Unit 9.1. Basic Concepts of PL/SQL
Introduction to PL/SQL
When Oracle applications are built using multitiered architecture, the Oracle database resides on a database server. The program that makes requests against this database resides on a client machine. This program can be written in C, Java, or PL/SQL. PL/SQL is closely integrated with Oracle SQL, but it adds constructs that are not native to Oracle SQL. PL/SQL is a procedural language that allows you to code a series of steps or procedures. It allows you to control the flow of logic by such constructs as IF-THEN-ELSE statements, loops, and so on. PL/SQL, like any other programming language, has syntax and rules that determine how programming statements work together.
PL/SQL allows you ...