This course provides an in-depth look at PL/SQL in the SQL*Plus environment in order to create and populate data structures. This course is suitable for Oracle10g users.

« Hide The Details

Topics Covered In This Course

PL/SQL OVERVIEW

SQL*PLUS
INTRODUCTION
CLIENT/SERVER ARCHITECTURE
INTERNET/INTRANET ARCHITECTURE
ISO (Incorporating ANSI and BSI) Standards

PROGRAMMING

INTRODUCTION
LOCAL VARIABLES
DATABASE DERIVED VARIABLES
USER DEFINED RECORDS
USER DEFINED VARIABLES
VARIABLE ASSIGNMENT
IF ... ELSE
ORACLE PL/SQL CASE STATEMENTS
ORACLE PL/SQL CASE EXPRESSIONS
ORACLE SEARCHED CASE STATEMENTS
GENERAL STATEMENT CONSIDERATIONS
FOR LOOP
WHILE
(REPEAT UNTIL) LOOP
GOTO AND LABELS

EXCEPTION HANDLING

INTRODUCTION
USER DEFINED
ORACLE PREDEFINED
ORACLE DEFINED
SQLCODE AND SQLERRM
NESTED BLOCKS

CURSORS

INTRODUCTION
CURSOR
OPEN
FETCH
CLOSE
CURSOR FOR LOOP
DATA MODIFICATIONS
IMPLICIT CURSORS
CURSOR VARIABLES

STORED PROCEDURES AND STORED FUNCTIONS

INTRODUCTION
ADVANTAGES
STORED PROCEDURES
INPUT PARAMETERS
OUTPUT PARAMETERS
I/O PARAMETERS
STORED FUNCTIONS
LOCAL PROCEDURES AND FUNCTIONS
COMPILATION
USER DEFINED ERRORS
EXTERNAL PROGRAMS

What You Can Expect

Upon completion of the course students will be able to write PL/SQL Control Structures and edit, store & recall PL/SQL blocks.

Who Should Take This Course

Programmers and support staff who wish to gain a comprehensive understanding of how the Oracle Procedural Level/Structured Query Language is used.

Recommended Prerequisites

Students should be computer literate with a good knowledge of Oracle SQL*Plus and the standard editor available on their hardware platform. Previous attendance of our Oracle SQL & SQL*Plus Parts One and Two courses is highly recommened.

Training Style

This course is highly interactive and consists of theory coupled with plenty of hands-on practical sessions.

« Hide The Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.

Notify me the next time this course is confirmed!

Can't find the course you want?
Call us at 800.533.3893, or
email us at info@verhoef.com

Privacy Notice