Oracle PL/SQL Stored Program Units

Level
Logo Focus on Training

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.
  • View related products with starting dates: Oracle and PL/SQL.

Focus on Training offers this product as a default in the following regions: N/A

Description

This course is designed for Oracle database administrators and software development personnel who need to write new, or maintain existing, PL/SQL triggers, program units and packages.

To provide the skills needed to develop, write and maintain triggers, stored program units and packages.

Course Objectives
To provide the skills needed to develop, write and maintain triggers, stored program units and packages.

Skills Gained
This course will enable delegates to:

Implementing various types of trigger.
Creating and invoking stored procedures.
Creating and executing stored functions.
Developing and using packages.
Using package features and constructs effectively.
Managing stored program units and de…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Oracle, PL/SQL, CompTIA A+ / Network+ / Security+, IT Security, and Retail (Management).

This course is designed for Oracle database administrators and software development personnel who need to write new, or maintain existing, PL/SQL triggers, program units and packages.

To provide the skills needed to develop, write and maintain triggers, stored program units and packages.

Course Objectives
To provide the skills needed to develop, write and maintain triggers, stored program units and packages.

Skills Gained
This course will enable delegates to:

Implementing various types of trigger.
Creating and invoking stored procedures.
Creating and executing stored functions.
Developing and using packages.
Using package features and constructs effectively.
Managing stored program units and dependencies.
Using Native Dynamic SQL and the Oracle-supplied package UTL_FILE.
Handling CLOBs, BLOBs and BFILEs using the package DBMS_LOB.

Course Content

Database triggers
Procedures
Functions
Packages
Using PL/SQL Records and Tables in Packages
Managing subprograms
Oracle-supplied Packages
Handling Large Objects

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.