Schedule today!

Call Peggy at
  (800) 252-0652

Contact Us

More Oracle

Related Courses

PL/SQL for Developers

Recommended Duration:
2 Days
Oracle 12c R2.
(courses for ealier Oracle versions available)
Participants will learn to use PL/SQL to enhance the operations of their Oracle applications. Several exercises will take students from the basics of PL/SQL through fairly extensive routines complete with looping, cursors, and error handling. Audience
Application developers and designers who will use PL/SQL in their applications.
Prior knowledge of Oracle fundamentals and basic SQL is necessary. No previous experience with PL/SQL is required.
Major Topics
  • Introduction to PL/SQL, syntax and fundamentals
  • PL/SQL statements including Arithmetic, Looping, and Conditional Logic
  • Error handling (Oracle-defined & user-defined)
  • Using cursors (Implicit & Explicit)
  • PL/SQL Tables
  • User Defined Records and Objects
  • Creating Procedures, Functions, and Packages
  • PL/SQL Parameters
  • Triggers
  • Built-in Packaged Procedures
  • Bulk bind
  • New features of PL/SQL
  • Using PL/SQL from SQL*Plus, SQL Developer, or other GUI
  • Extended (128 byte) names
There are eight hands-on machine exercises.