On-site & Public, Instructor-led, Hands-on IT Training
(International 01) 908.233.8900
  400+ Course Offerings:

Search for Course:

OR5470 Oracle Advanced PL/SQL Programming
Duration2 Days
Delivery MethodInstructor Led, Hands-on Workshops
Public Price$1195.00

DESCRIPTION (Return to Top)

The course provides attendees with the background to develop stored PL/SQL programs including functions, procedures, packages, and triggers.

Commonly used predefined packages provided with the Oracle DBMS are examined. Discussions include how these packages could be used as part of in-house applications. Additional PL/SQL features such as overloading programs, collections (arrays), bulk processing and autonomous transactions are also presented. Workshops provide students with the opportunity to use these features and evaluate their potential role in an application.

This course can be taught for any Oracle version.

AUDIENCE (Return to Top)

Programmers and Database Administrators responsible for the development or maintenance of application systems which access an Oracle database.

TOPICS (Return to Top)

Review of PL/SQL Syntax

  • PL/SQL on the Server
  • Advanced Features
  • BULK Operations
  • Oracle Supplied Packages
  • Autonomous Programs / Transactions


OR5460 Oracle PL/SQL Programming or equivalent experience.