PL/SQL Packages

This course is included in our On-demand training solution.


To create and work with Oracle 10g packages

Target Audience

Database administrators, application developers, and database operators


Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases, the SQL programming language, and stored procedures; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata

Expected Duration

165 min.

Course 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.