Training on Oracle Programing & Development

The Oracle Program training course introduces the delegate to Oracle's PL/SQL programming language and provides practical experience in writing stand-alone programs, developing database triggers and implementing stored functions, procedures and packages. It also introduces some of the Oracle-supplied packages.

Skills Gained

The delegates will practise:

• Writing and running PL/SQL programs from SQL*Plus or SQL Developer
• Declaring and using variables and constants
• Assigning and manipulating values
• Using SQL statements within PL/SQL
• Implementing conditional execution and loop constructs
• Declaring and using cursors with and without parameters
• Updating data with cursors
• Trapping and handling errors and exceptions in code
• Implementing nested and labelled loops and blocks
• Raising exceptions
• Handling PL/SQL records and Index-By tables
• Using PL/SQL Index-By table built-in functions
• Implementing various types of trigger
• Creating, managing and invoking stored procedures
• Creating, managing and executing stored functions
• Developing and using packages
• Using package features and constructs effectively
• Wrapping packages
• Using Cursor Variables
• Using records and Index-By tables or associative arrays in packages
• Implementing Bulk Binding and Bulk Collecting techniques
• Managing program unit dependencies
• Implementing Native Compilation and Compile-time Warnings
• Implementing Native Dynamic SQL
• Using a variety of Oracle-supplied packages

Who will the Course Benefit?

Oracle database administrators, software development personnel and database support staff who need to write PL/SQL scripts and implement or maintain database triggers, program units and packages.

Course Objectives

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