Follow Us :

Oracle Program with PL/SQL

Course_Reference: 
SA-OPPL
Manufacturer: 
0
Training_Provider: 
18
Summary: 

This course is designed for Oracle programmers and developers and provides practical experience in writing stand-alone PL/SQL programs and database triggers, functions, procedures and packages. It also introduces some of the Oracle-supplied packages including DBMS_LOB for handling Large Objects.

PreRequisites: 

Attendance on the pre-requisite course Oracle SQL*Plus or iSQLPlus products and practical experience in writing SQL statements. Some prior programming experience will also prove advantageous.

Objectives: 

By the end of this course, the delegate will be able to write PL/SQL programs, manage stored program units, implement package constructs and handle Large Objects programmatically. The content of the course covers all the topics required for the Oracle PL/SQL Developer Certified Associate Examination #1Z0-147.

  • The PL/SQL Program Structure
  • Variables and Constants
  • Using SQL in PL/SQL Programs
  • Generating Output
  • IF Statements and LOOP Constructs
  • Using Cursors
  • Handling Exceptions
  • PL/SQL Records and Tables
  • Creating Triggers, Stored Procedures and Functions
  • Passing Parameters to Stored Program Units
  • Creating Packages
  • Implementing Package Features and Constructs
  • Using PL/SQL Records and Tables in Packages
  • Managing Stored Program Units
  • Using Native Dynamic SQL
  • Overview of Oracle-supplied Packages
  • The DBMS_LOB Package for Handling Large Objects

Description: 

This course is designed for Oracle programmers and developers and provides practical experience in writing stand-alone PL/SQL programs and database triggers, functions, procedures and packages. It also introduces some of the Oracle-supplied packages including DBMS_LOB for handling Large Objects.

Keywords: 
Oracle Program,PL/SQL,oracle programmers,oracle developers,oracle supplies packages

Software Vendor

IT Technical

Business Skills