How do you declare a PL/SQL table? Explain it with an example.
What will be an ideal response?
A PL/SQL TABLE declaration is done in two steps, like a record declaration:
? Declare a PL/SQL Table type with a TYPE statement. The structure could use
any of the scalar data types.
? Declare an actual table based on the type declared in the previous step.
For example, TYPE position_name_table_type IS TABLE OF position.PosDesc%TYPE INDEX BY BINARY_INTEGER; Position_table position_name_table_type;
You might also like to view...
Match each term with the correct statement below.
A. A formal statement of best practices promulgated by an agency with the formal authority to issue them B. Allow managers to chart the organization's course over time C. Requirements dictated by an agency or other legally constituted unit, which must be complied with D. A process of gathering evidence and drawing conclusions about the correctness or quality of a given subject E. Designates a condition or state in which the organization can be assured to satisfy relevant legal and regulatory requirements F. The process of generating proof and drawing conclusions from the evidence that can be attested to G. Legal mandates dictated by a body with the authority to issue those mandates H. Documents how the organization will verify and validate that the execution of the compliance function is correct I. The specific activities that will be undertaken to satisfy some policy dictate
HTTPS is different than HTTP because
a. of how it transforms or reformats the data. b. it is a combination of HTTP and the Secure Sockets Layer (SSL). c. it extracts data from source databases. d. it stores data in the data warehouse.
Match the example with the function or feature:
I. =A54 II. =$A54 III. =$A$54 IV. =SUM(A54:B97) V. "Ohio" A. Function B. Relative reference C. Ensures text entry D. Mixed reference E. Absolute reference
When a digitally signed document is received, the recipient’s computer uses the sender’s ____ key to verify the digital signature.
A. private B. public C. organizational D. token