Realistic Software Training

Author / Training Specialist / Developer

Oracle SQL & PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts

On-site Course Syllabus

Course Description

Day 1

This outline is based upon the five day SQL and PL/SQL offering

Day 4 Morning - The Basics of PL/SQL

Writing Your First Program Executing the PL/SQL Program Code Block Components and Block Labels   Code Block Sections Block Labels, Labels, and the GOTO keyword Comments Declaring Variables and Assigning Values   Defining Variables   Character Definitions   Numeric Definitions   Other Definitions   Constrained Definitions   Aggregate and PL/SQL Record Definitions   Assigning Values to Variables   Using the INTO Assignment Keyword with PL/SQL Records The IF-THEN-ELSE and ELSIF Structures   The IF-THEN-ELSE Structure   Nested IF-THEN-ELSE Structures   The ELSIF/THEN Structure

Day 4 Afternoon -  The Basics of PL/SQL (Cursors and Loops)

Cursors Declaring the Cursor Cursor Commands Using Aggregate Variables with Cursors Cursor Attributes Differences between a Cursor and a SELECT/INTO Statement Loops The LOOP Structure The WHILE Loop Using Aggregate Variables with Cursors      Cursor Attributes Differences between a Cursor and a SELECT/INTO statement Loops The LOOP Structure The WHILE Loop Using the %FOUND Cursor Attribute with Loops Nested Loops Locking Records with the FOR UPDATE Option The FOR UPDATE OF Option The WHERE CURRENT OF Option For Loops Numeric FOR Loops The Basic Cursor FOR Loop Defining the Cursor in the Cursor For Header Nested FOR Loops

Day 1          Day 2          Day 3          Top          Day 5