Name three types of PL/SQL modules. Describe each module with one characteristic specific to the module.
What will be an ideal response?
Procedure – A named block that can perform one or more tasks. It uses IN, OUT and IN OUT papameters to pass values back and forth. It can be executed as a standalone program with EXECUTE statement. Function – A named block that normally performs one task and returns a value to the calling block. It uses IN parameters. It cannot be executed as a standalone program. Package – A collection of private and public PL/SQL objects such as scalar and
composite variables, constants, exceptions, cursors, records, tables, functions and
procedures. It has specification and body.
You might also like to view...
In Outline view, a paragraph that does not have a Heading style is identified as ________ text
A) promoted B) unmarked C) body D) demoted
The software developer retains the copyright, but gives blanket permission to download ____ software from the Internet, install it, copy it multiple times, and give copies to friends.
A. shareware B. freeware C. commercial D. demo