Chapter 15. Packages
Beginner
Q: | |||||||||||||||||||||||||
15-1. | No. You canât execute the package as a whole; itâs simply a container for other PL/SQL elements. You can execute procedures and functions defined in the package specification, as well as reference data structures defined in a package specification (a constant, variable, exception, etc.). | ||||||||||||||||||||||||
Q: | |||||||||||||||||||||||||
15-2. | You would use dot notation, in the form of package.element, as in: financial_pkg.calc_totals (...); | ||||||||||||||||||||||||
Q: | |||||||||||||||||||||||||
15-3. | You donât need to qualify a package element with its package name under these circumstances:
| ||||||||||||||||||||||||
Q: | |||||||||||||||||||||||||
15-4. | This table explains the use of the packaged elements in this code:
The STANDARD package contains the definitions of many of the elements of the PL/SQL language, including datatypes, exceptions, and functions. DBMS_STANDARD contains database-related programs, including COMMIT, ROLLBACK, and RAISE_APPLICATION_ERROR. They are the defaults, so dot notation is not required. | ||||||||||||||||||||||||
Q: | |||||||||||||||||||||||||
15-5. | Any data structure declared in a package specification ... |
Get Oracle PL/SQL Programming: A Developer's Workbook now with the O’Reilly learning platform.
O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.