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