ORACLE DATABASE 11G R2: PL/SQL FUNDAMENTALS II-DEVELOP PROGRAM UNITS – GTD4

Course Description

This Oracle 11g course will equip students to develop database server-side PL/SQL program units within an Oracle database.

^^

Duration

3 days

^^

Target Audience

Target audience for this course is all Oracle professionals. Among the specific groups for whom this course will be helpful are:

  • Application designers and developers
  • Database administrators

^^

Course Prerequisites

Those who wish to attend this course require attendance of the courses below, similar courses, or have the equivalent experience.

If you have any questions or doubts as to whether you meet the pre-requisites for this course, or indeed are wondering which course best suits you, please consult with us to discuss your suitability for course attendance.

^^

Suggested Follow on Courses

^^

Course Content

INTRODUCING DATABASE PROGRAM UNITS

• ABOUT DATABASE PROGRAM UNITS

• TYPES OF PL/SQL PROGRAM UNITS

• TYPES OF STORED PROGRAM UNITS

• ADVANTAGES OF USING STORED PROGRAM UNITS

CREATING STORED PROCEDURES & FUNCTIONS

• ABOUT STORED PROCEDURES & FUNCTIONS

• CREATING PROCEDURES & FUNCTIONS

• EXECUTING PROCEDURES & FUNCTIONS

MAINTAINING STORED PROCEDURES & FUNCTIONS

• RECOMPILING & DROPPING PROGRAMS

• DATA DICTIONARY STORAGE

• MANAGING DEPENDENCIES

 

CREATING & MAINTAINING PACKAGES

• ABOUT PACKAGES

• CREATING PACKAGES

• ADVANCED PROGRAMMING TECHNIQUES

• MAINTAINING PACKAGES

ADVANCED CURSOR TECHNIQUES

• USING CURSOR VARIABLES

• USING CURSOR EXPRESSIONS

 

USING SYSTEM-SUPPLIED PACKAGES

• DBMS_OUTPUT()

• UTL_FILE()

REATING DATABASE TRIGGERS

• ABOUT DATABASE TRIGGERS

• STATEMENT-LEVEL TRIGGERS

• ROW-LEVEL TRIGGERS

• EXAMPLES OF TRIGGERS

• INSTEAD OF TRIGGERS

• EMPLOYING TRIGGERS WITHIN AN APPLICATION

MAINTAINING DATABASE TRIGGERS

• CALL SYNTAX

• TRIGGER MAINTENANCE TASKS

• SHOW ERRORS TRIGGER

• DROP TRIGGER

• ALTER TRIGGER

• HANDLING MULTIPLE TRIGGERS FOR A TABLE

• HANDLING MUTATING TABLE ISSUES

 

IMPLEMENTING SYSTEM EVENT TRIGGERS

• WHAT ARE SYSTEM EVENT TRIGGERS?

• DEFINING THE SCOPE

• AVAILABLE SYSTEM EVENTS

• SYSTEM EVENT ATTRIBUTES

© 2011 Sideris Courseware Corporation

^^

See more Database Technologies courses