Demonstrate nested PL/SQL blocks : Code Block « PL SQL Programming « Oracle PL/SQL Tutorial






SQL>
SQL> declare
  2     v_custno                NUMBER := 100;
  3  begin
  4     dbms_output.put_line(v_custno) ;
  5     declare
  6             v_state         CHAR(2):= 'NY' ;
  7     begin
  8             dbms_output.put_line(v_custno || v_state) ;
  9     end ;
 10  end ;
 11  /
100
100NY

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL>








24.4.Code Block
24.4.1.This is an anonymous procedure, so it has no name
24.4.2.A PL/SQL Block
24.4.3.Uses a PL/SQL Nested Block
24.4.4.Inline procedure
24.4.5.the forward slash on a line by itself says execute this procedure
24.4.6.Inner function
24.4.7.Select the first names for the Doe family from the Worker table.
24.4.8.Inner procedure in an anonymous function
24.4.9.Demonstrate nested PL/SQL blocks