For further information, please contact the Course Enquiry Team on 0161 9204466 or alternatively email us:

Oracle PL/SQL Program Blocks

What's the course about?

By the end of this course, the delegate will be able to write and manage stored program units, implement package constructs and features and handle Large Objects programmatically.

Areas covered by the course include:
• Creating DML Triggers
• Creating ON DATABASE and ON SCHEMA Triggers
• Managing Triggers
• Creating and Managing Stored Procedures
• Parameters and Parameter Modes
• Local Subprograms
• Autonomous Transactions
• Creating and Managing Stored Functions
• Deterministic Functions
• Using Stored Functions in SQL
• Creating and Managing Packages
• Implementing Package Features and Constructs
• Wrapping Packages
• Using PL/SQL Records and Tables in Packages
• Bulk Binding Operations
• Managing Dependencies
• Native Compilation and Compile Time Warnings
• Native Dynamic SQL
• The DBMS_METADATA Package
• Overview of the UTL_FILE Package
• Using UTL_MAIL
• Overview of DBMS_SCHEDULER
• Overview of the HTP Package
• Large Objects - CLOBs, BLOBs and BFILEs
• Using the DBMS_LOB Package for Handling Large Objects

How long is the course and when will it be taught?

This is a three day course.

Where is the course taught?
At Manchester New Technology Institute (MNTI), One Central Park, Northampton Road, Manchester.

How much will the course cost me?
You can call our Course Enquiry Team on FREECALL 0800 068 8585 for details of the fees for this course.

What qualifications or experience do I need to do this course?
Practical experience of Oracle SQL*Plus or iSQL*Plus and a good working knowledge of the fundamentals of the PL/SQL programming language are required. This can be gained by attending the pre-requisite courses.

Which qualifications will I be awarded if I successfully complete the course?
An Oracle PL/SQL Stored Program Units certificate will be awarded

What will I be able to do after I've completed this course?
On completion of this course, delegates could go on to study on the Oracle Forms course at Manchester NTI. The PL/SQL Stored Program Units course can enhance the career opportunities of Oracle developers.

How do I apply?
For further information or to apply for a course, contact our Course Enquiry Team on FREECALL 0800 068 8585 or email enquiries@mancat.ac.uk.

Click here to Make an Enquiry

To register your interest in one of these courses or to request further information, please complete the online enquiry form or contact the Course Enquiry Team directly.

Course Enquiry Team

Tel: 0800 068 8585
Email: