Anonymous block

From Oracle FAQ
Jump to: navigation, search

An anonymous block is an unnamed sequence of actions. Since they are unnamed, anonymous blocks cannot be referenced by other program units.

In contrast to anonymous blocks, stored/ named code blocks include Packages, Procedures, and Functions.

Here are some example anonymous blocks written in PL/SQL:

begin
   DBMS_OUTPUT.put_line('Hello world!');
end;
declare
  i number;
begin
  i := 10;
end;
Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #