Creating an Anonymous Block - 1









The interactions in this eCourse require Javascript to be enabled.



 

Creating an
Anonymous Block: Part 1



previous|next








Anonymous blocks are unnamed blocks. They are
declared inline at the point in an application where they are to be executed
and are compiled each time the
application is executed.
Features of Anonymous Blocks

Anonymous blocks are not stored in the database,
and they are passed to the PL/SQL engine for execution at run time.
You will not be able to to invoke or call the block
that you wrote earlier because blocks are anonymous and do not exist
after they are executed.
Anonymous blocks can serve as nested blocks inside
procedures, functions, and other anonymous blocks.

Anonymous Block Structure:




[DECLARE]
BEGIN
---Executable
Statements---
[EXCEPTION]
END;