CMSC 461 Database  Management Systems

Oracle & SQL

Your programming projects and assignments may be completed using Oracle 10g on the GL system at UMBC. You many use another Oracle system such as Oracle Express on your own laptop.

ORACLE

Oracle Access at UMBC

Oracle Express

 

SQL

Oracle Documentation Library

Oracle 10g SQL Reference

 

E/R Modeling

Dia - diagram tool for Linux, MacOS X, Unix, and Windows

 

JDBC

Oracle JDBC Documentation and Tutorials

Oracle JDBC Tutorial

Java / JDBC Setup

 

SQL*Plus

A Simple Guide to SQL*Plus (*** Recommended ***)

SQL*Plus User's Guide and Reference

SQL*Plus Quick Reference

 

Stored Procedures

PL/SQL Examples (*** Recommended ***)

PL/SQL User's Guide

PL/SQL 101

 

Demo—Call Oracle Stored Procedure from Java using IN and OUT parameters

Demo—Call Oracle Stored Function from Java  returning CURSOR to result set

 

Exception Handling with RAISE_APPLICATION_ERROR

Returning a JDBC result set from an Oracle stored procedure