Oracle - PL/SQL Anonymous Block in Oracle

Home > Oracle

PL/SQL Anonymous Block in Oracle

Q

What Is an Anonymous Block in Oracle?

✍: FYIcenter.com

A

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;

⇒Understanding PL/SQL Language Basics

⇒⇒Oracle Database Tutorials

2018-11-29, 614👍, 0💬

Enter Comments in PL/SQL in Oracle
How To Enter Comments in PL/SQL in Oracle? There are two ways to enter comments into PL/SQL codes: SQL Statement Style: Starts you comment any where in the line but prefixed with '--'. The comment ends at the end of the line. C Language Style: Starts you comment any where in the line with '/*' and e... 2018-12-26, 610👍, 0💬

Different Types of PL/SQL Code Blocks in Oracle
What Are the Different Types of PL/SQL Code Blocks in Oracle? There are 3 types of PL/SQL code blocks: Anonymous Block - A block of codes with no name. It may contain a declaration part, an execution part, and exception handlers. Stored Program Unit - A block of codes with a name. It is similar to a... 2018-11-29, 592👍, 0💬

PL/SQL Named Program Unit in Oracle
What Is a Named Program Unit in Oracle? A named program unit is a PL/SQL code block with an name. It consists of three parts: Declaration Part - Defining the program unit name, calling parameters, local variables and local procedures. Declaration part is required. Execution Part - Defining execution... 2018-11-29, 575👍, 0💬

PL/SQL Procedure in Oracle
What Is a Procedure in Oracle? A procedure is a named program unit. It consists of three parts: Declaration Part - Defining the procedure name, calling parameters, local variables and local procedures. Declaration part is required. Execution Part - Defining execution logic with executable statements... 2018-11-29, 532👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.