UMBC CMSC461, Database Management Systems, Summer 2005.

Oracle Related Material

This page will be updated during the semester.

• Instructions for Oracle at UMBC
• Oracle 8i Documentation.
  • SQL*Plus Quick Reference
  • SQL*Plus User's Guide and Reference
  • Oracle 8i SQL Reference
  
  
• A Simple Guide to ORACLE SQLPLUS
• Oracle and Java
  • Introduction to JDBC from the CS145 course at Stanford.
  • Sample Java program for interacting with Oracle using the Oracle JDBC drivers.
  • JDBC Thin drivers for Oracle 8.1.5 and 8.1.6. To download the driver(s), rightclick your browser's pointer over the link and use the "Save Link Target As" option.
  • To compile and run the sample Java program above,
    • Use Java 1.2 or higher. Ensure that java and javac are in your path environment variable.
    • Set the CLASSPATH environment variable to include the complete pathname of your Oracle JDBC driver. For example, if your driver is located at /usr/guest/oracle815.jar, then use setenv CLASSPATH ".:/usr/guest/oracle815.jar".
    • Compile, javac JdbcSample.java, and run java JdbcSample.