Oracle PL/SQL Stored Program Units

Course

In Leeds and London

£ 995 + VAT

Description

  • Duration

    3 Days

By the end of this course, the delegate will be able to write and manage stored program units, implement package constructs and features. They will also be able to describe and use some of the Oracle-supplied packages.Together with the PL/SQL course, this course is suitable for delegates intending to sit the Oracle examination #1Z0-147: Program with PL/SQL. Note: Exams are not included as part of the course. Before taking any exam, delegates must ensure they have the recommended experience.

Facilities

Location

Start date

Leeds (West Yorkshire)

Start date

On request
London
See map
3-5 Crutched Friars, EC3N 2HR

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Course content
  • CreatingDMLTriggers
  • Creating ONDATABASEand ONSCHEMATriggers
  • Managing Triggers
  • Creating and Managing Stored Procedures
  • Parameters and Parameter Modes
  • Local Subprograms
  • Autonomous Transactions
  • Creating and Managing Stored Functions
  • Deterministic Functions
  • Using Stored Functions inSQL
  • Creating and Managing Packages
  • Implementing Package Features and Constructs
  • Wrapping Packages
  • Cursor Variables
  • Using PL/SQL Records and Tables or Associative Arrays in Packages
  • Bulk Binding and Bulk Collecting Operations
  • Managing Dependencies
  • Native Compilation and Compile Time Warnings
  • The DBMS_SQL Package
  • Native DynamicSQL
  • Oracle Supplied Packages
  • The DBMS_METADATA Package
  • Overview of DBMS_SCHEDULER

Oracle PL/SQL Stored Program Units

£ 995 + VAT