What is the purpose of the %TYPE and %ROWTYPE attributes?
What will be an ideal response?
Oracle documentation suggests several techniques to use in coding program units to avoid errors associated with program changes:
Use the ‘%TYPE' and ‘%ROWTYPE' attributes in variable declarations. These declarations instruct the system to assign the variable data type based on the underlying table column data type at runtime. If changes are made to tables, such as column length or data type, program units using these columns in variables or parameters do not have to be edited. Keep in mind this does not avoid other logic errors that can be raised by data type modifications. For example, if we change a variable data type from NUMBER to VARCHAR2 and the program unit code uses a numeric function, such as round on this variable, it now raises an error.
You might also like to view...
The ________ represents the sequence of steps in the accounting process completed during the fiscal period
a. matching principle b. fiscal year c. accounting cycle d. fiscal period
Internal Control Principles One of the COSO principles of internal control requires organizations to demonstrate a commitment to attract, develop, and retain competent individuals in alignment with objectives. Discuss how this can be done
Which of the following is a cause of action against the auditor for breach of contract?
a. Violating client confidentiality. b. Providing the audit report on time. c. Failing to discover an immaterial error or employee fraud. d. Withdrawing from an audit engagement with justification.
Discuss how to choose and develop your approach when planning presentations
What will be an ideal response?