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.
Hiee..
what is meant by program unit ORDERTOTAL??
Does it mean program unit of Oracle Forms 10g?
or it is refering to plsql package?
Please Clarify Someone…
Thanks nad Regards,
Farhan Ahmad Khan
Oracle Developer @ Naurus (Pvt) Ltd.
Email: [email protected]
Hai,
As per the Question and answer, I guess the program unit ORDERTOTAL is referred as a Package.
Regards,
Kalai
a program unit can be a procedure or a function aswell
i guess 😉
Here the ORDERTOTAL is supposed to be the package, the wrapped procedure within the procedure or function could not be invoked by other program unit directly,