O'Reilly logo

Oracle® Web Application Programming for PL/SQL® Developers by Benjamin Rosenzweig, Solomon Morse, Melanie Caffrey, Susan Boardman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required