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...
The W3C’s concept of _________relates to providing a single resource that is configured for optimal display on multiple types of devices.
a. accessibility b. validation c. responsive web design d. One Web
Convert the Swing application MemoSaver, as given in Listing 13.10 of the previous chapter, to an applet, and place it in an HTML document.
The applet is easily created by following the directions in the text to convert a Swing application to an applet.
A secure stamp of authentication on a document that is electronically encryption based is called ________
A) change history ID B) finalized ID C) Live ID D) digital ID
Phishing is controlled by using S/MIME
Indicate whether the statement is true or false