What are the two types of blocks in PL/SQL? What are the differences between them?
What will be an ideal response?
PL/SQL is a block-structured language. A program can be divided into logical
blocks. The block structure gives modularity to a PL/SQL program, and each object
within a block has “scope.” Blocks are of two types:
An anonymous block is a block of code without a name. It can be used anywhere in a
program and is sent to the server engine for execution at runtime.
A named block is a block of code that is named. A subprogram is a named block that can
be called and can take arguments. A procedure is a subprogram that can perform an
action, whereas a function is a subprogram that returns a value. A package is formed from
a group of procedures and functions. A trigger is a block that is called implicitly by a
DML statement.
You might also like to view...
Laser printers are usually faster at printing in black and white than inkjet printers
Indicate whether the statement is true or false
Web copyright law in the United States says that images on the Web have a(n) ________ copyright
Fill in the blank(s) with correct word