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)
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.