Using SQL*Plus in the Labs
Connecting to the Oracle Server From Home
SQL*Plus
Creating a Database Table
The Select Statement
SQL Functions
Updating Tables
Creating an Index
Formatting Query Results
Advanced Queries
Creating Views
The Data Dictionary
Using PL/SQL
Sample Programs:
Basic Syntax
Using Exceptions
Accessing a Table
Using a Cursor
Procedures and Functions
Triggers
Physical Storage in Oracle
Embedded SQL
Sample Programs in C++:
connect.pc
getstock.pc
listval.pc
Using the Pro*C/C++ Precompiler
Object Oriented Features in Oracle
Privileges
Lab1 - Connecting to Oracle Using SQL*Plus
Lab2 - Creating the Investments Database
Lab3 - Using SQL
Lab4 - Using SQL - Advanced Queries
Lab5 - System Tables
Lab6 - Integrity Constraints
Lab7- PL/SQL and Triggers
Lab8 - Physical Storage
Lab9 - Using the PRO*C/C++ Precompiler
Lab10 - User-Defined Types
Lab11 - Privileges; Commit/Rollback Commands
Lab12 - Creating the Investments Data Warehouse