This course provides the student with an in-depth look at PL/ SQL in the SQL*Plus enviroment in order to create and use user defined packages, as well as being able to use Oracle supplied packages. This course also covers creation of Database Triggers.

« Hide The Details

Topics Covered In This Course

PACKAGES

INTRODUCTION
PACKAGE STRUCTURE
PACKAGE CREATION

BUILT-IN PACKAGES

INTRODUCTION
STANDARD AND DBMS_STANDARD
DBMS_ALERT
DBMS_DDL
DBMS_JOB
DBMS_LOCK
DBMS_PIPE
DBMS_SESSION
DBMS_SQL
DBMS_TRANSACTION
DBMS_UTILITY
UTL_FILE
ORACLE10g PACKAGES

NATIVE DYNAMIC SQL (NDS)

INTRODUCTION
DBMS_SQL Vs. NDS
NDS COMMANDS
EXECUTE IMMEDIATE
OPEN FOR (CURSOR VARIABLES)
USING BIND VARIABLES WITH NDS

DDL AND DATABASE LEVEL TRIGGERS

DDL TRIGGERS
DATABASE LEVEL TRIGGERS
A LOGON TRIGGER

COLLECTIONS

INTRODUCTION
DECLARING NESTED TABLES and VARRAYs
INITIALISING COLLECTIONS
MANIPULATING ELEMENTS
COLLECTION METHODS
BULK BINDS

EXTERNAL PROCEDURES & JAVA INTEGRATION

INTRODUCTION
EXTERNAL PROCEDURES
JAVA INTEGRATION
PUBLISHING JAVA TO PL/SQL
COLLECTION METHODS

What You Can Expect

On completion of the course, students will be able to write user defined Packages and Triggers, produce PL/SQL code that uses Oracle supplied Packages and create re-usable code with NDS.

Who Should Take This Course

Programmers and support staff who wish to gain a more comprehensive understanding of how the Oracle Procedural Level/Structured Query Language can be used in order to utilize Packages and Triggers.

Recommended Prerequisites

A good knowledge of SQL, SQL*Plus and the standard editor available on their target hardware platform. Understanding of Oracle PL/ SQL programming concepts and techniques is also required. Previous attendance of our course Oracle10g PL/SQL Programming Part One is highly recommended.

Training Style

This course is highly interactive and consists of theory coupled with plenty of hands-on practical sessions.

« Hide The Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.

Notify me the next time this course is confirmed!

Can't find the course you want?
Call us at 800.533.3893, or
email us at info@verhoef.com

Privacy Notice