What Is An Anonymous Block?

1.	What Is An Anonymous Block?
Answer» An anonymous block is a PL/SQL code block with no name. It consists of three parts: Declaration Part - Defining local variables and local procedures. Declaration part is optional. EXECUTION Part - Defining execution logic with executable statements. Execution part is required. Exception Part - Defining error handling logics. Exception part is optional. Here how a complete anonymous block should LOOK like: DECLARE // Declaration statements BEGIN // Executable statements EXCEPTION // Error handling statements END; An anonymous block is a PL/SQL code block with no name. It consists of three parts: Here how a complete anonymous block should look like: DECLARE // Declaration statements BEGIN // Executable statements EXCEPTION // Error handling statements END;

Answer»

An anonymous block is a PL/SQL code block with no name. It consists of three parts:

Declaration Part - Defining local variables and local procedures. Declaration part is optional.
EXECUTION Part - Defining execution logic with executable statements. Execution part is required.
Exception Part - Defining error handling logics. Exception part is optional.

Here how a complete anonymous block should LOOK like:

DECLARE // Declaration statements
BEGIN // Executable statements
EXCEPTION // Error handling statements
END;

An anonymous block is a PL/SQL code block with no name. It consists of three parts:

Here how a complete anonymous block should look like:

DECLARE // Declaration statements
BEGIN // Executable statements
EXCEPTION // Error handling statements
END;

Discussion