The course outlines techniques used in the advanced manipulation and extraction of data and adds a procedural element to the processing of data from an Oracle database. Lectures are combined with sets of exercises designed to illustrate the points covered. These exercises are to be completed by the delegate.
This course has been developed for real-world, commercial scenarios by our expert instructors. See below for detailed syllabus. If you have a technical question, please email firstname.lastname@example.org
What you will learn
1. Produce procedural programs using PL/SQL
2. Perform transactions using PL/SQL.
3. Manipulate data using advanced techniques including nested functions.
Introduction to Oracle PL/SQL Training Course Outline
Creating Procedures, Functions and Packages
Executing & Using Procedures, Functions & Packages
Private & Public Execution
One-time only Procedures
Declarations and variable assignment.
Assigning Default Values and Constants
Defining Records and Tables of Records
SQL*Plus commands in PL/SQL
Restrictions on Embedded SQL
Manipulating Multiple Records
Defining and using Ref Cursors.
For Update and Where Current of Clauses
Embedded Insert, Update, Delete commands.
Exiting Loops to a Label
Block Labels and Nested Blocks
Basic, FOR, While and Cursor For loops
Nested Loops and Variable Scope
Handling Runtime Errors
System Handled Exceptions
User Defined Exceptions
PRAGMA INIT and Compiler Instructions
How to continue processing after an Exception
Debugging Your PL/SQL