Seer Computing Limited - Site Map
Home Public Courses Oracle Courses Microsoft Courses Java Courses Consultancy


Contents

This intensive hands on
PLSQL I training course is broken down into twelve sections and includes the following aspects:

Basic structure of PLSQL program
Oracle Explicit and Implicit Cursors
Oracle PLSQL Database Objects - Functions, Procedures, Packages and Triggers
Using PLSQL to communicate with the Operating System
Advanced Techniques such as PLSQL %rowtype
Using PLSQL to create Oracle Dynamic SQL

Exercises

There are practical and comprehensive exercises scheduled throughout the Oracle PLSQL training to ensure delegates leave with a sound theoretical and practical knowledge.
The exercises include:

 Simple PLSQL processing - Inserting records
Using For, While, Explicit and Implicit Loops in Oracle PLSQL
Creating Database Objects such as Triggers, Functions, Procedures and Packages
Using PLSQL to read and write ascii files
Simple Dynamic PLSQL using Execute Immediate


Duration

Three Days

 Oracle PL SQL training course, in house, on site and public courses
© Copyright
Seer Computing Ltd.
PLSQL language is Oracle's versatile procedural extension to SQL, which capitalises on SQL's functionality and can increase database efficiency, effectiveness, scalability, portability and security.

This is part one of a two part course and takes Developers up to a stage where they are able to create Database objects such as triggers and packages, as well as work with PLSQL in Forms and Reports.

Pre-Requisite Course(s)
Essential SQL

Next Course(s)
PLSQL II
8i New Features for Developers
9i New Features for Developers
Forms 10g
Reports 10g

Valid HTML 4.01 Transitional

Level A conformance icon, W3C-WAI Web Content Accessibility Guidelines 1.0

Get Adobe Reader

Bookmark and Share