Chapter 2 : PL/SQL Blocks - Anonymous Block

Опубликовано: 28 Июнь 2026
на канале: KONSIN KONSIN
105
3

PL/SQL program units organize the code into blocks. A block without a name is known as an anonymous block. The anonymous block is the simplest unit in PL/SQL. It is called anonymous block because it is not saved in the Oracle database.

An anonymous block is an only one-time use and useful in certain situations such as creating test units. The following illustrates anonymous block syntax: