Oracle8i:SQL, PL/SQL and SQL Plus

Introduction to Oracle8i: SQL, PL/SQL, and SQL*Plus
Introduction to SQL*Plus
Introduction to SQL
Introduction to PL/SQL

SQL*Plus
Using SQL*Plus for Editing
Using SQL*Plus to Work with Files
Using SQL*Plus for Formatting Output
Using SQL*Plus for Storing Temporary Values

Restricting and Sorting Data
WHERE Clause
ORDER BY Clause

SQL Functions
Expressions in a SELECT Statement
Single Row Functions
Group Functions

Working with Multiple Tables
Joins
Subqueries
Set Operators

Tables and Constraints
Creating and Modifying Tables
Integrity Constraints
Managing Data in Tables
Transaction Control Language Commands

More Database Objects
Sequences, Synonyms, and Indexes
Views
Controlling Database Objects

Building PL/SQL Blocks
Creating PL/SQL Blocks
Manipulating Data in PL/SQL

PL/SQL Control Structures
Conditional Control Structures
Iterative Control Structures

Cursors
Introduction to Cursors
Implicit Cursors
Explicit Cursors
Cursor Loops

Exception Handling
Introduction to Exception Handling
Types of Exceptions

PL/SQL
Defining and Using Collections
Collection Methods

Procedures and Functions
Developing Procedures and Functions
Passing Parameters

Oracle Packages
Developing Packages
Oracle Supplied Packages

Oracle Triggers
Building a Trigger
Trigger Restrictions

After completing this course, students will know how to:

Use SQL, PL/SQL, and SQL*Plus Use SQL*Plus commands Restrict and sort data Use built-in SQL functions Work with multiple tables Create and modify tables and constraints Create and use other database objects Build a PL/SQL block Use PL/SQL control structures Process cursors in PL/SQL Handle runtime exceptions Work with collections of data Develop procedures and functions Develop Oracle packages Create Oracle triggers

Prerequisites

Students should have knowledge of Oracle Fundamentals or equivalent experience.