December 2002
Intermediate to advanced
745 pages
17h 26m
English
book
Oracle® Web Application Programming for PL/SQL® Developers
by Susan Boardman, Melanie Caffrey, Solomon Morse, Benjamin Rosenzweig
Content preview from Oracle® Web Application Programming for PL/SQL® Developers
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...