|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Nov. 2, 2002
|
| |
| 402-339-7493 |
| 402-636-3171 |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
|
This outline is based upon the five day SQL
and PL/SQL offering
| Day 5 Morning - Advanced
PL/SQL (Handling Exceptions and Named Procedures) |
|
Exception Handling |
|
Predefined
SQL Exceptions |
|
|
Handling an Exceptions with a Predefined
Exception |
|
|
Defining Error Handlers |
|
|
The OTHERS Exception |
|
|
Using SQLCODE and SQLERRM |
|
|
Using the Exception Section For Your Own
Processing |
|
PL/SQL Records and Arrays |
|
|
PL/SQL Table Attributes |
|
|
Deleting PL/SQL Table Records |
|
Named Procedures |
|
|
Creating or Changing, Executing, and
Deleting a Named Procedure |
|
|
The Header Section |
|
|
Header Parameters |
|
|
Inputting Values by Using the IN
Parameter Mode |
|
|
Calling a Procedure from a Procedure and
Outputting Values by Using the OUT Parameter Mode |
|
|
Defining a Named Procedure within a
Procedure |
|
| Day 5 Afternoon -
Advanced PL/SQL (Functions, Packages, Cursor Variables, Processing
Objects, and using Java) |
|
Functions |
|
|
Function
Structure |
| |
Creating
and Using a Function |
| |
Creating
and Using a Function in a SELECT Clause |
| |
Using a
Function in an Assignment Statement within a Procedure |
|
Packages |
|
|
Package Components |
|
|
Package Specification Template |
|
|
Package Body Specification |
|
|
Employee Package Example |
|
Cursor Variables |
|
Processing Objects |
|
|
Nested Object Tables |
|
PL/SQL and Java |
|
|
Creating and Using a Java Class within
PL/SQL |
|
|
Loading the Java Source Code into the
Database |
|
Day 1
Day 2
Day 3
Day 4
Top
|
