CS 330
Lecture 9
- Short demos of Access features: creating the switchboard
(Deepa), making an application (Karin), Security by password (Maliha)
- Natural Join in SQL.
- Null values. Textbook Ch. 9.5. Examples. Issues: 3-valued
logic, OUTER JOINS
(assigned reading: Ch. 9.5.4).
- Embedded SQL. Reading from textbook, Ch. 9.6. Main topics:
- SQL preprocessor
- host variables
- cursors: declaration, open, fetch, close.
- (briefly) connecting to the database
- (briefly) SQLCA communication area for exceptions and special
conditions (e.g. end-of-file type of message for end of query)
-
- Short demo on how to access Oracle in Burton basement lab (Biliana)
Ileana Streinu