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