Warning: include() [function.include]: URL file-access is disabled in the server configuration in /nfs/cs/classes/www/06U/cis399oracle/lectures/week4.php on line 14

Warning: include(http://www.cs.uoregon.edu/classes/06U/cis399oracle/utility_functions.php) [function.include]: failed to open stream: no suitable wrapper could be found in /nfs/cs/classes/www/06U/cis399oracle/lectures/week4.php on line 14

Warning: include() [function.include]: Failed opening 'http://www.cs.uoregon.edu/classes/06U/cis399oracle/utility_functions.php' for inclusion (include_path='.:/private/apps/php-5.2.4/lib/php') in /nfs/cs/classes/www/06U/cis399oracle/lectures/week4.php on line 14

CIS 399 - Introduction to Oracle and SQL

Slides for this week's lectures

Week 4 Lecture Notes

Monday, July 17 2006

No class.

Tuesday, July 18 2006

Announcements: new homework
Simple and Complex Views
Listing Views
Dropping Views

Wednesday, July 19 2006

Intro to PL/SQL
1. Anonymous blocks
  1. Declarative section
  2. Variables
  3. Constants
  4. Executable section
  5. Actual code
  6. Exception handling section
2. Implicit Cursors
3. Loops
  1. Simple Loops
  2. While Loops
  3. For Loops

Thursday, July 20 2006

Intro to PL/SQL, continued
1. Explicit Cursors
  1. Open cursor
  2. Fetch Into
  3. Close cursor
2. For Loops with cursors
3. If-Then-Else
4. If-Then-Else statements
5. Named Blocks
  1. Functions
  2. Procedures

Answers to Questions / Clarifications

Does Oracle release (close) a cursor on an exception?
From what I understand from the Oracle documentaion, once the cursor variable goes out of scope (i.e. when the procedure exits), the cursor is closed by the system.

Back to Main Page