Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
This Oracle/SQL tutorial provides a detailed introduction to the SQL query language and the Oracle Relational Database Management System. Further information about Oracle and SQL can be found on the web site www.db.cs.ucdavis.edu/dbs. Comments, corrections, or additions to these notes are welcome. Many thanks to Christina Chung for comments on the previous version. | Oracle SQL Tutorial1 Michael Gertz Database and Information Systems Group Department of Computer Science University of California Davis gertz@cs.ucdavis.edu http www.db.cs.ucdavis.edu This Oracle SQL tutorial provides a detailed introduction to the SQL query language and the Oracle Relational Database Management System. Further information about Oracle and SQL can be found on the web site www.db.cs.ucdavis.edu dbs. Comments corrections or additions to these notes are welcome. Many thanks to Christina Chung for comments on the previous version. Recommended Literature The complete Oracle Documentation is available online at technet.oracle.com. Free subscription 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 SQL Programming 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 following article Can Turker and Michael Gertz Semantic Integrity Support in SQL 1999 and Commercial Object- Relational Database Management Systems. The VLDB Journal Volume 10 Number 4 241-269. Revised Version 1.01 January 2000 Michael Gertz Copyright 2000. Contents 1. SQL - Structured Query Language 1.1. Tables 1 1.2. Queries Part I 3 1.3. Data Definition in SQL 6 1.4. Data Modifications in SQL 9 1.5. Queries Part II 11 1.6. Views 19 2. SQL Plus Minimal User Guide Editor Commands Help System 20 3. Oracle Data Dictionary 23 4. Application Programming 4.1. PL SQL 4.1.1 Introduction 26 4.1.2 Structure of PL SQL Blocks 27 4.1.3 Declarations 27 4.1.4 Language Elements 28 4.1.5 Exception Handling 32 4.1.6 Procedures and Functions 34 4.1.7 Packages 36 .