TAILIEUCHUNG - Oracle/SQL Tutorial

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 . 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@ http 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 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 . Free subscription Oracle Press has several good books on various Oracle topics. See oracle O Reilly has about 30 excellent Oracle books including Steven Feuerstein s Oracle PL SQL Programming 3rd edition . See . 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 January 2000 Michael Gertz Copyright 2000. Contents 1. SQL - Structured Query Language . Tables 1 . Queries Part I 3 . Data Definition in SQL 6 . Data Modifications in SQL 9 . Queries Part II 11 . Views 19 2. SQL Plus Minimal User Guide Editor Commands Help System 20 3. Oracle Data Dictionary 23 4. Application Programming . PL SQL Introduction 26 Structure of PL SQL Blocks 27 Declarations 27 Language Elements 28 Exception Handling 32 Procedures and Functions 34 Packages 36 .

• Cơ sở dữ liệu
• data management
• data programming
• computer skills
• Oracle
• SQL Tutorial
• Database
• Structured Query Language
• Oracle Data Dictionary
• Application Programming
• Decision Support Systems
• Data collection
• Database Management Systems in DSS
• Data Mining
• Data Visualization
• data storage
• information management
• computer data
• Bug Management
• Management information systems
• Lecture Management information systems
• Information systems in business
• Business applications
• Data resource management
• Logical data elements
• Business data communications
• Data communications
• Network management
• Configuration management
• Network management tools
• Data communications networks
• Data communications system
• programming data
• computer documentation
• computer tips
• installation tips
• data architecture
• Lecture Data communications
• Physical layer
• Data link layer
• Network management system
• Database management systems
• Lecture Database management systems
• Data Definition Language commands
• Data Manipulation Language commands
• Data Control Language commands