Course Title:
Advanced PL/SQL

Duration: 2 days

Course Overview
This course is the follow-on from Fundamentals of PL/SQL. The course covers all areas of PL/SQL that will enable developers to write a fully working batch system. The main areas of PL/SQL that the course focuses on are procedures, functions and packages. The course also covers triggers, collections and exception handling in named-blocks to complete the delegate’s knowledge of PL/SQL.

Target Audience


Systems developers and DBA’s who need to know more about database stored procedure, functions and packages.

Prerequisites


Attendees should have experience of Oracle databases and experience of using SQL and PL/SQL. Ideally delegates will have attended the Fundamentals of SQL & SQL*Plus and Fundamentals of PL/SQL courses.

Course Content


Collections
Index-By Tables and their uses
IBT Functions
Varying Arrays
Nested Tables
Management Issues

Procedures and Functions
Creating procedures with no arguments
Creating procedures with arguments
Creating functions
Error handling
Dropping procedures and functions

Packages
How packages are used
The package body and specification
Creating, using and dropping packages
Initialising packages
Overloading procedures
Viewing source code
Compiling functions, procedures and packages

Triggers
Trigger components
Statement and row triggers
Multi-purpose triggers
Customising error conditions
DDL Triggers
Database event triggers
Enabling and disabling triggers

Supplied Packages
DBMS_ALERT
DBMS_JOB
DBMS_OUTPUT
DBMS_PIPE
DBMS_SQL

We have used Pentland for a number of years to provide for our needs in a number of areas, including .NET, C Sharp and UML.

Pentland’s ability to provide training tailored to the needs of our group has been critical to our ongoing success.

Software Control Manager
Waters


Enter your email address to register for our newsletter:


IT Technical & End User
Course Listings

For further information, or to make a telephone booking, or to receive a competitive quotation for an in-house course, you can call Pentland Training now on 0800 328 2766.

All of our training courses can be delivered on your own site, at Pentland Training facilities, or at an off-site venue.

follow us on Twitter