Introduction to Oracle & SQL - CIS50

The information at this site is in draft form and is the property of Priscilla Grocer. The information may not be duplicated or distributed without her permission. ©Copyright 2002

Category Information
Smart Board Notes Class notes in answer to questions about decoder and functions
Class notes on grouping (where and having)
Class notes Oracle indexes
Class notes on primary and foreign keys using inventory tables - 1 page of sketches
Notes on PL/SQL loops in Oracle
Recreation of class notes on establishing the property tax relational database
Cursor information to accompany the handout continuing example 1 using cursors
Notes from in class on the cursor examples that use the manager id and the table
Notes from class discussion on Oracle and procedures
Notes from class questions about cursors - review
Notes from class discussion on cursors and triggers