Course Outline
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.
Course Content
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 sales@jbinternational.co.uk
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
PL/SQL
PLSQL Blocks
Creating Procedures, Functions and Packages
Executing & Using Procedures, Functions & Packages
Private & Public Execution
One-time only Procedures
Overloading
Declarations and variable assignment.
Data Types
Bind variables
Assigning Default Values and Constants
Table Arrays
Defining Records and Tables of Records
SQL*Plus commands in PL/SQL
Embedded SQL
Restrictions on Embedded SQL
Cursors
Defining Cursors
Manipulating Multiple Records
Parameterising Cursors
Defining and using Ref Cursors.
Data Manipulation
For Update and Where Current of Clauses
Embedded Insert, Update, Delete commands.
Conditional Branches
Labels
Exiting Loops to a Label
Block Labels and Nested Blocks
Loops
Basic, FOR, While and Cursor For loops
Nested Loops and Variable Scope
Exception handling
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
