Table of Contents

  1. Introduction
    1. Activity 29
  2. Creating a VB Program to Link to Oracle
    1. Step 2a
    2. Step 2b
    3. Step 2c
    4. Step 2d
    5. Step 2e
    6. Step 2f
    7. Activity 30
  3. Link Visual Basic to Oracle
    1. Subroutines
    2. Declare the necessary variables
    3. Make the Connection
    4. Activate the Command Query
    5. End the Program
    6. List Employees
    7. List Jobs
    8. Simulate an Error
    9. Code for Error Simulation
    10. Creating SQL Statements
    11. Further VB Programs
    12. Activity 31
    13. Activity 32
    14. Data Model and Tables
    15. Answer to Activity 32
  4. Additional Reading Material
    1. Useful Websites
    2. Electronic Resources and the Internet
  5. Outcome 5 Assessment