0845 450 6120

Oracle PL/SQL Stored Program Units

This course is designed for Oracle database administrators and software development personnel who need to write new, or maintain existing, PL/SQL triggers, program units and packages.
Reset

Learning Objectives

To provide the skills needed to develop, write and maintain triggers, stored program units and packages.

Pre-Requisites

This course is designed for Oracle database administrators and software development personnel

Course Content

Course Objectives

To provide the skills needed to develop, write and maintain triggers, stored program units and packages.

Skills Gained

This course will enable delegates to:

Implementing various types of trigger.
Creating and invoking stored procedures.
Creating and executing stored functions.
Developing and using packages.
Using package features and constructs effectively.
Managing stored program units and dependencies.
Using Native Dynamic SQL and the Oracle-supplied package UTL_FILE.
Handling CLOBs, BLOBs and BFILEs using the package DBMS_LOB.

Course Content

Database triggers
Procedures
Functions
Packages
Using PL/SQL Records and Tables in Packages
Managing subprograms
Oracle-supplied Packages
Handling Large Objects

Exams & Certification

None

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the request service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

Our Customers Include