spacer

Home > Oracle Training > Oracle PL/SQL Introduction

Oracle PL/SQL Introduction

Duration: 2 days Level: Introduction

Who should attend | Prerequisites | Content | Sample Notes | Next Class | Printer Friendly Print this page

Class Summary

This class builds on the foundation of our Oracle SQL*Plus class, introducing delegates to Oracle's stored procedure language PL/SQL. Versions of this class can be organised for Oracle 8i and 9i.

The class consists of a mixture of lecture and hands on lab exercises.

Who Should Attend

This class is intended for analysts, junior developers, designers, beginning administrators and managers with SQL experience.

Prerequisites

A grounding in relational database concepts; familiarity with the use of graphical user interfaces. Attendance on our SQL*Plus class or equivalent experience is recommended.

Content

  • PL/SQL Overview: Basic block structure, defining variables and constants; variable scope and lifetime; composite data types; records; PL/SQL tables; other sub-types.

  • PL/SQL Conditional Processing; IF statements; FOR statements; WHILE loops.

  • Executing SQL statements: using SELECT statements; implicit and explicit cursors; using INSERT, UPDATE and DELETE statements; handling execution errors.

  • Exception handlers: overview; pre-defined exceptions; non pre-defined exceptions; user defined exception; nested block techniques.

  • Stored Program Units: types; using procedures; functions; packages; triggers; 9i trigger features.

Sample notes

To be uploaded shortly ...

Suggested next class

Oracle Database Administration

 

   

 Search this site...
       
 
Web Hosting by Lunarpages

This page last updated on
October 6, 2010 9:12 AM