Introduction to SQL*PLUS

What is it?

A command line interface to the database. Analagous to an operating system shell.

When do I use it?

Practice/Test SQL
Debugging Database
Bulk Data Load/Unload

How do I use it?

Starting SQL*PLUS
Creating a Table
Inserting Tuples in a Table
Selecting on a Table
Executing .sql File
Select: Another Example
Select: Who Makes The Big Bucks?
Update: It's Time For A Raise!!! (I)
Update: It's Time For A Raise!!! (II)
Delete: Let's Downsize The Company
Joins & Group By: Best Department
Miscellaneous SQL*PLUS
Exercises
 


Bob Dugan bdugan@stonehill.edu