What is the most appropriate location to store the code that calculates the discounts?

You want to create a PL/SQL block of code that calculates discounts on customer orders. -This
code will be invoked from several places, but only within the program unit ORDERTOTAL.
What is the most appropriate location to store the code that calculates the discounts?

You want to create a PL/SQL block of code that calculates discounts on customer orders. -This
code will be invoked from several places, but only within the program unit ORDERTOTAL.
What is the most appropriate location to store the code that calculates the discounts?

A.
A stored procedure on the server.

B.
A block of code in a PL/SQL library.

C.
A standalone procedure on the client machine.

D.
A block of code in the body of the program unit ORDERTOTAL.

E.
A local subprogram defined within the program unit ORDERTOTAL.



Leave a Reply 0

Your email address will not be published. Required fields are marked *