|
Provided by: Serebra Learning Corporation PL SQL Packages |
![]() |
Training
Provided by Serebra Learning Corporation
To create and work with Oracle 10g packages Database administrators, application developers, and database operators
|
|
||||||||
PL SQL Packages
Audience
Database administrators, application developers, and database operators
Topics
Objectives
- PL/SQL Packages
- recognize the structure of a package and outline the visibility of its components.
- create a package in PL/SQL for a given scenario.
- select the code required to invoke a package subprogram and view and remove packages in PL/SQL.
- create, invoke, and view a package.
- use PL/SQL overloading and the standard package to declare and access subprograms.
- implement a forward declaration in a PL/SQL package and initialize package variables.
- identify the functions of the PL/SQL wrapper and the features of the wrapped code.
- overload a subprogram in a package, initialize package variables, and wrap PL/SQL code.
- outline the role of package functions and identify the restrictions associated with calling package and stored functions from SQL expressions.
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...

