• Home
• Course Catalogue
• Certifications
• Onsite Training
• Scheduled Training
• E-Learning
• Managed Services
• Consulting
• Company
• Special Offers
• News
• Links
• Enquiry And Feedback Form

Training Course Outline

IT Vendor Courses   Oracle Developer Training Courses

PL/SQL Stored Program Units

View course dates

Course Duration: 3 days

Course Code: OSPU

Course Description:

This course, designed for Oracle programmers and developers, provides practical experience in writing triggers, functions, procedures and packages.  It also introduces some of the Oracle-supplied packages including DBMS_LOB for handling Large Objects.

 

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.

Prerequisites:

Attendance on SQL*Plus (OSP) and PL/SQL (OPI).

Prerequisite courses:

SQL*Plus

PL/SQL

Relevant Certifications:

Oracle PL/SQL and Oracle Forms Developer

This course includes the following modules:

Course topics:

• 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 or Associative Arrays in Packages
• Bulk Binding and Bulk Collecting Operations
• Managing Dependencies
• Native Compilation and Compile Time Warnings
• The DBMS_SQL Package
• 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

 

Location	Duration	RRP	Jul	Aug	Sep	Oct	Nov	Dec
Click on course date to make a booking, check availability, or find out about available discounts.
Leeds	3 days	£995				1 - 3	26 - 28
London	3 days	£995	30 - 1		17 - 19		5 - 7	17 - 19

<< Previous 6 Months

Next 6 Months >>

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.

Save as PDF

Print this course