|
| |
Examples
SQL and C code for examples and in-book Exercise Solutions, to be completed
by September 1, 2000. Out-of-book (OOB) exercise solutions are available
to instructors via
Morgan Kaufman's page on DBPPP..
| Basic SQL Queries, Sections 3.1 to 3.5 |
Examples |
Exercises |
| Advanced SQL, Section 3.6 |
Examples |
Exercises |
| Basic SQL Queries, Sections 3.7-3.9 |
Examples |
Exercises |
| SQL Updates, Inserts, Deletes, Section 3.10 |
Examples |
OOB only. |
| Power SQL Queries, Section 3.11 |
Examples |
Exercises |
| Basic Object-Relational SQL, for Oracle, Sec.4.2.1 |
Examples |
Exercises |
| Basic Object-Relational SQL, for Informix, Sec. 4.2.2 |
Examples |
Exercises |
| O-R Collections, for Oracle, Sec. 4.3.1 |
Examples |
Exercises |
| O-R Collections, for Informix, Sec. 4.3.2 |
Examples |
Exercises |
| O-R User-defined Functions, for Oracle, Sec. 4.4.1 |
Examples |
Exercises |
| O-R User-defined Functions, for Informix, Sec. 4.4.2 |
Examples |
Exercises |
| Embedded C/SQL, Chapter 5, for Oracle: makefile,
prompt.h, prompt.c,
db_error.pc |
5.1.1, 5.1.2,
5.5.1, 5.5.2,
5.6.1, 5.6.2,
5.6.3,
printrow.pc |
5.2, 5.10 |
| Embedded C/SQL, Chapter 5, for DB2UDB: makefile,
embprep for makefile, prompt.h,
prompt.c, db_error.sqc |
5.1.1,
5.1.2, 5.5.1,
5.5.2, 5.6.1, 5.6.2,
5.6.4, prrow.sqc |
5.2, 5.10 |
| Integrity, Views, etc., Chapter 7 (to come) |
Examples |
Exercises |
| Indexing, Chapter 8 (to come) |
Examples |
Exercises |
|