An example of an anonymous block : Begin End Block « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. Begin End Block

An example of an anonymous block

 

SQL>
SQL> -- An example of an anonymous block.
SQL> -- Count up by hundreds until we get an error.
SQL>
SQL> DECLARE
  2
  3    hundreds_counter  NUMBER(1,-2);
  4  BEGIN
  5    hundreds_counter := 100;
  6    LOOP
  7      DBMS_OUTPUT.PUT_LINE(hundreds_counter);
  8      hundreds_counter := hundreds_counter + 100;
  9    END LOOP;
 10  EXCEPTION
 11    WHEN OTHERS THEN
 12      DBMS_OUTPUT.PUT_LINE('That is as high as you can go.');
 13  END;
 14  /
100
200
300
400
500
600
700
800
900
That is as high as you can go.

PL/SQL procedure successfully completed.

SQL>








Related examples in the same category

1.Three sections - declarative, executable, and exception.
2.Block-Based Development
3.The PL/SQL Block
4.Block Nesting
5.The executable section needs at least one line of code to be valid.
6.Five level nested statement
7.no executable code
8.Building Blocks of PL/SQL
9.A Nested Block Example
10.Block with name
11.Outer Block name and inner block name
12.This script demonstrates the structure of a block
13.Nested block
14.Plain SQL and PL/SQL program