Oracle Database 10g: The SQL*Loader and PL/SQL Release 2


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/Description
To provide an overview of how to use the SQL*Loader and PL/SQL in an Oracle 10g database

Target Audience
Anyone wanting to learn about Oracle Database 10g database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration (hours)
2.0

Lesson Objectives

Oracle Database 10g: The SQL*Loader and PL/SQL Release 2

  • identify the function of the SQL*Loader and the files it uses.
  • recognize how to load data using the SQL*Loader.
  • load data using the SQL*Loader.
  • identify the characteristics of PL/SQL objects, functions, and procedures.
  • recognize the characteristics of PL/SQL packages and triggers and identify the configuration options that control PL/SQL performance.
  • recognize the basic concepts of PL/SQL.

    • Course Number:
    249299_eng