The BEGIN section

 

Can contain variable assignments, Embedded SQL 
and calls to other functions and procedures.

A BEGIN-END block can contain nested DECLARE-BEGIN-END sub blocks.
The use of nested sub-blocks allows the use of local variables
with limited scope.

Each plsql block should be terminated with / on a line by itself

Related Commands:

Related Views:



Back to the Top

Simon Sheppard
SS64.com