SUMMARY:   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. AUDIENCE:   Programmers and support staff who wish to gain a comprehensive understanding of how the Oracle Procedural Level/Structured Query Language is used. 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. DURATION:   3 Days APPROACH:   This course is highly interactive and consists of theory coupled with plenty of hands-on practical sessions. OBJECTIVES:   Upon completion of the course students will be able to write PL/SQL Control Structures and edit, store & recall PL/SQL blocks. COURSE CONTENT:   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