Chaonchon

has ) om eฺ c ailฺ uid m Oracle Database 11g: SQL @g dent G m Fundamentalsu rco s St I (lfe thi ra s Mo Volume IIe• Student Guide u dor se to e orr licen C do ble n rna sfera e is F -tran Lu on n

a

D49996GC11 Edition 1.1 April 2009 D59981

Unauthorized reproduction or distribution prohibitedฺ Copyright© 2010, Oracle and/or its affiliatesฺ

Authors
Puja Singh Brian Pottle

Copyright© 2009, Oracle. All rights reserved. Disclaimer This document contains proprietary information and is protected by copyright and other intellectual property laws. You may copy and print this document solely for your own use in an Oracle training course. The document may not be modified or altered in any way. Except where your use constitutes "fair use" under copyright law, you may not use, share,download, upload, copy, print, display, perform, reproduce, publish, license, post, transmit, or distribute this document in whole or in part without the express authorization of Oracle. The information contained in this document is subject to change without notice. If you find any problems in the document, please report them in writing to: Oracle University, 500 Oracle Parkway, Redwood Shores,California 94065 USA. This document is not warranted to be error-free. Restricted Rights Notice If this documentation is delivered to the United States Government or anyone using the documentation on behalf of the United States Government, the following notice is applicable: U.S. GOVERNMENT RIGHTS The U.S. Government’s rights to use, modify, reproduce, release, perform, display, or disclose thesetraining materials are restricted by the terms of the applicable Oracle license agreement and/or the applicable U.S. Government contract. Trademark Notice

Technical Contributors and Reviewers
Claire Bennett Tom Best Purjanti Chang Ken Cooper László Czinkóczki Burt Demchick Mark Fleming Gerlinde Frenzen Nancy Greenberg Chaitanya Koratamaddi Wendy Lo Timothy Mcglue Alan Paulson Bryan RobertsAbhishek Singh Lori Tritz Michael Versaci Lex van der Werff

has ) om eฺ c ailฺ uid m @g dent G m rco s Stu (lfe thi ra Editors Mo o use r Raj Kumar Amitha Narayan edo nse t rr e Vijayalakshmi Narasimhan o C c do ble li n Graphic Designer rna sfera Satish Fe Bettegowda is -tran Lu on n Publishers
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may betrademarks of their respective owners.

a

Sujatha Nagendra Syed Ali

Unauthorized reproduction or distribution prohibitedฺ Copyright© 2010, Oracle and/or its affiliatesฺ

Contents

Preface I Introduction Lesson Objectives I-2 Lesson Agenda I-3 Course Objectives I-4 Course Agenda I-5 Appendixes Used in the Course I-7 Lesson Agenda I-8 Oracle Database 11g: Focus Areas I-9 Oracle Database 11gI-10 Oracle Fusion Middleware I-12 Oracle Enterprise Manager Grid Control 10g I-13 Oracle BI Publisher I-14 Lesson Agenda I-15 Relational and Object Relational Database Management Systems I-16 Data Storage on Different Media I-17 Relational Database Concept I-18 Definition of a Relational Database I-19 Data Models I-20 Entity Relationship Model I-21 Entity Relationship Modeling Conventions I-23Relating Multiple Tables I-25 Relational Database Terminology I-27 Lesson Agenda I-29 Using SQL to Query Your Database I-30 SQL Statements I-31 Development Environments for SQL I-32 Lesson Agenda I-33 The Human Resources (HR) Schema I-34 Tables Used in the Course I-35 Lesson Agenda I-36 Oracle Database 11g Documentation I-37 Additional Resources I-38

has ) om eฺ c ailฺ uid m @g dent G m rco s Stu(lfe thi ra Mo o use r edo nse t rr Co lice ndo rable a ern nsfe F uis n-tra L o n

a

Unauthorized reproduction or distribution prohibitedฺ Copyright© 2010, Oracle and/or its affiliatesฺ

iii

Summary I-39 Practice I: Overview I-40 1 Retrieving Data Using the SQL SELECT Statement Objectives 1-2 Lesson Agenda 1-3 Capabilities of SQL SELECT Statements 1-4 Basic SELECT Statement 1-5...