You are building two forms. Each form has a button and a non-base table field. When the button is pressed, a complicated calculation is executed. The calculation code queries data from several tables in the database. When the calculation completes, it returns a single value to the non-base table field. To optimize performance and maintainability, which PL/SQL structure should be used?

Question

Accepted Answer

C. a stored subprogram in the database

Answer

A. a subprogram in each form

Answer

B. a trigger in each form

Answer

D. a subprogram in a library that is attached to each form

You are building two forms. Each form has a button and a non-base table field. When the button is pressed, a complicated calculation is executed. The calculation code queries data from several…

Question

Options

How the community answered

Community Discussion