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

Get Oracle® Web Application Programming for PL/SQL® Developers now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.