sql notes oracle free

SQL Notes
Please refer to the pages linked below for help with the SQL labs and assignments:
• SQL setup (Lab 1 exercise for running SQL*Plus from CRL and WinAthena PCs)*
• SQL help*
• PARCELS database*
• URISA database*
• Outer Join help*
• ZONING database
o Zoning Variances*
o 1980 Census data (by Boston NSA)*
o Schema of Decision, Use, NSA, Neighbrhd Lookup Tables*
o Sub-Neighborhood lookup table*
o SQL examples using zoning variances*
o Grouping zoning applicants via 'lookup' tables*
o Zoning Variance Database Evolution Chart*
• SQL*Plus Formatting and Documentation Notes*
• Oracle 8i Documentation Available online at http://technet.oracle.com/docs/products/oracle8i/doc_index.htm. The documentation is generally available both in HTML format (good for viewing online in a browser) and PDF format (better for printing).
Particularly useful references:
o Oracle 8i SQL Reference. This is the authoritative reference for Oracle's flavor of SQL.
o SQL*Plus Quick Reference. A concise guide to SQL*Plus commands.
o SQL*Plus Reference. The full SQL*Plus manual.
o Oracle 8i Designing and Tuning for Performance. Suggests ways to tune queries and database designs to improve performance. Offers insights into how Oracle operates.
o Oracle 8i Error Messages. Provides extra information about Oracle's sometimes cryptic error messages.
Note: To access this documentation you will need to register for a free membership to the Oracle Technology Network. To register, click the 'My Profile' button in the upper right portion of the page and then complete and submit the registration form.