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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
