Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:


Oracle 12c PL/SQL Intermediate

GK# 7499

Course Overview

In this course, you will learn about intermediate and advanced features of Oracle 12c PL/SQL procedural language for SQL. You will also learn how to control data sharing and locking, debug and use error reporting procedures use Oracle supplied packages, as well as develop database triggers, stored procedures, and functions.

Delivery Format Options

  • Virtual Classroom Live

    Virtual Classroom Live

    Experience expert-led online training from the convenience of your home, office or anywhere with an Internet connection.


    $2565 CAD

    3 day

  • Private Group Training

    Private Group Training

    Train your entire team in a private, coordinated professional development session at the location of your choice.

    Receive private training for teams online and in-person.

Request a date or location for this course.

What You'll Learn

  • The PL/SQL Environment
  • PL/SQL Program Structure
  • Native Compilation
  • Update, Insert, and Delete Statements
  • Error Functions / Debugging
  • Defining, Executing, and Testing Functions and Procedures
  • Creating Package Specifications and Bodies
  • Creating Triggers
  • Using Oracle Supplied Packages
  • Understanding Advanced PL/SQL Features

Who Needs To Attend

Application developers and database administrators who need a comprehensive understanding of Oracle 12c PL/SQL language

Course Outline

Download Course Outline