Oracle Database Sql

Volume I • Student Guide

D49996GC11
Edition 1.1
April 2009
D59980

Unauthorized reproduction or distribution prohibited. Copyright© 2011, Oracle and/or its affiliates.

Antonio Arroyo Paz (arroyopaz@yahooฺcom) has a non-transferable license to use this Student Guideฺ

Oracle Database 11g: SQL
Fundamentals I

Copyright © 2009, Oracle. All rights reserved.

Puja Singh
BrianPottle

Disclaimer

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 Roberts
Abhishek Singh
Lori Tritz
Michael Versaci
Lex van der Werff

This document contains proprietary information and isprotected 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, ordistribute 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
Ifthis 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 these training materials are restricted by the terms of the applicable Oracle
license agreementand/or the applicable U.S. Government contract.
Trademark Notice
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other
names may be trademarks of their respective owners.

Editors
Raj Kumar
Amitha Narayan
Vijayalakshmi Narasimhan

Graphic Designer
Satish Bettegowda

Publishers
Sujatha Nagendra
Syed Ali

Unauthorized reproduction or distributionprohibited. Copyright© 2011, Oracle and/or its affiliates.

Antonio Arroyo Paz (arroyopaz@yahooฺcom) has a non-transferable license to use this Student Guideฺ

Authors

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 11g I-10Oracle 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

iii

Unauthorized reproductionor distribution prohibited. Copyright© 2011, Oracle and/or its affiliates.

Antonio Arroyo Paz (arroyopaz@yahooฺcom) has a non-transferable license to use this Student Guideฺ

Contents

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
Selecting All Columns 1-6
Selecting Specific...