Tutorial Oracle 10G

1Oracle/SQL TutorialMichael GertzDatabase and Information Systems GroupDepartment of Computer ScienceUniversity of California, Davisgertz@cs.ucdavis.eduhttp://www.db.cs.ucdavis.eduThis Oracle/SQL tutorial provides a detailed introduction to the SQL query language and theOracle Relational Database Management System. Further information about Oracle and SQLcan be found on the web site www.db.cs.ucdavis.edu/dbs.Comments, corrections, or additions to these notes are welcome. Many thanks to ChristinaChung for comments on the previous version.Recommended LiteratureThe complete Oracle Documentation is available online at technet.oracle.com. Free sub-scription!Oracle Press has several good books on various Oracle topics. See www.osborne.com/oracle/O’Reilly has about 30 excellent Oracle books, including Steven Feuerstein’s Oracle PL/SQLProgramming (3rd edition). See oracle.oreilly.com.Jim Melton and Alan R. Simon: SQL: 1999 - Understanding Relational Language Components(1st Edition, May 2001), Morgan Kaufmann.Jim Celko has a couple of very good books that cover advanced SQL queries and programming.Check any of your favorite (online)bookstore.If you want to know more about constraints and triggers, you might want to check the fol-lowing article: Can Tur¨ ker and Michael Gertz: Semantic Integrity Support in SQL:1999 andCommercial (Object-)Relational Database Management Systems. The VLDB Journal, Volume10, Number 4, 241-269.1revised Version 1.01, January ...