EASY EXPLANATION OF SQL, PL/SQL

Oracle-PL/SQL




06/14/23

, PL/SQL Architecture
 PL/SQL architecture defines how the PL/SQL blocks are executed in Oracle. O
provides PL/SQL engine that executes the Procedural Language part of a block.
 When an application program or a user invokes a PL/SQL block, it is submitted
PL/SQL engine available locally.
 PL/SQL engine extracts the Procedural Language statements of the block.
statements are then executed separately by the PL/SQL processor.
 The SQL statements in the block are passed to the SQL processor of Oracle s
These are separately executed.




06/14/23

, Here is the diagram showing architecture of PL/SQL




06/14/23

, Features of PL/SQL Architecture
•The first feature is PL/SQL compilation. PL/SQL engine works as a
run-time system. It is assigned the task of compilation and execution
of PL/SQL blocks submitted to server by users or application
programs.
•It is a separate component that can be installed in the database. It can
also be installed as an application development tool for specific
application needs.
•PL/SQL engine works as a compiler for PL/SQL block. If a block is
submitted with PL/SQL errors they are reported by the PL/SQL
Engine. A PL/SQL block is not executed until all errors are removed.



06/14/23