Griffin Software Home
Training ServicesCoursesFacilitiesConsultancy Services
Course List
Linux & Unix
Solaris TM
Oracle TM
Contact Us


Oracle PL/SQL Foundation

Oracle's Procedural Language for SQL (PL/SQL) provides programming logic features not contained within standard SQL. In this 3 day course, the student will learn to use the PL/SQL language with its various structures and constructs and then continue on to look at using PL/SQL for writing stored procedures, functions, triggers and more. Security issues of PL/SQL will also be covered. This course is based on Oracle 11g PL/SQL.

This course is aimed at application developers and database administrators.

Attendees need to be comfortable working with SQL and should have some programming experience in another programming language

click here for course content details Course Summary:
  • Triggers
  • PL/SQL Variables and Datatypes
  • PL/SQL Syntax and Logic
  • Stored Procedures and Functions
  • Exception Handling
  • Records, Collections and User Defined Types
  • Cursors
  • Bulk Operations
  • Using Packages
  • Creating Packages
  • Working with LOBs
  • Maintaining PL/SQL Code
  • Dynamic SQL

Back to top
© 2018 Griffin Software Ltd - All Trademarks acknowledged (3.16). Griffin Software Ltd, Tel: +353 (1) 4622277