PL/SQL Architecture

PL/SQL Architecture

A PL/SQL block contains both SQL statements and Procedural PL/SQL statements. The PL/SQL statements are executed by a PL/SQL execution engine, while the SQL statements are executed by the SQL Engine in the Oracle database.

The PL/SQL engine can reside either in the Oracle server or in a different server. When a PL/SQL block is submitted for execution, it first reached the PL/SQL engine. The PL/SQL engine executes the PL/SQL statements and sends the SQL statements to the SQL engine in the Oracle Database.

By submitting SQL and PL/SQL in blocks, we can reduce the number of round trips between the front end application and the Oracle database. Without PL/SQL we will have to perform the procedural and control statement execution in the front end and perform multiple round trips to the Oracle database to execute the SQL statements.