Ad Code



PL/SQL Execution Environment

PL/SQL Execution Environment

Wherever Pl/SQL technology is required (i.e., in the RDBMS core or in its tools), the PL/SQL engine accepts any valid PUSQL block as input (figure 4.2)

PL/SQL Execution Environment

The PL/SQL engine resides in the Oracle engine, the Oracle engine can process not only single SQL statements but also entire PL/SQL blocks.

These blocks are sent to the PL/SQL- engine, where procedural statements are executed and SQL statements are sent to the SQL, executor in the Oracle engine. Since the PL/SQL engine resides in the Oracle engine, this is an efficient and swill operation.

The call to the Oracle engine needs to be made only once to execute any number of SQL statements if these SQL sentences are bundled inside a PL/SQL block.