Oracle Database 10g: SQL
Fundamentals I
Volume I • Student Guide

D17108GC10
Edition 1.0
March 2004
D39189

®

Author

Copyright © 2004, Oracle. All rights reserved.

Nancy Greenberg

This documentation contains proprietary information of Oracle Corporation. It is provided under a license agreement containing restrictions on use and disclosure and is also protected by copyright law. Reverse engineering of the software is prohibited.
If this documentation is delivered to a U.S. Government Agency of the Department of
Defense, then it is delivered with Restricted Rights and the following legend is applicable: Technical Contributors and Reviewers
Wayne Abbott
Christian Bauwens
Perry Benson
Brian Boxx
Zarko …ver más…

3
Logging In to iSQL*Plus 1-24 iSQL*Plus Environment 1-25
Displaying Table Structure 1-26
Interacting with Script Files 1-28 iSQL*Plus History Page 1-32
Setting iSQL*Plus Preferences 1-34
Setting the Output Location Preference 1-35
Summary 1-36
Practice 1: Overview 1-37
2

1-22

Restricting and Sorting Data
Objectives 2-2
Limiting Rows Using a Selection 2-3
Limiting the Rows That Are Selected 2-4
Using the WHERE Clause 2-5
Character Strings and Dates 2-6
Comparison Conditions 2-7
Using Comparison Conditions 2-8
Using the BETWEEN Condition 2-9
Using the IN Condition 2-10
Using the LIKE Condition 2-11
Using the NULL Conditions 2-13
Logical Conditions 2-14
Using the AND Operator 2-15
Using the OR Operator 2-16
Using the NOT Operator 2-17
Rules of Precedence 2-18
Using the ORDER BY Clause 2-20
Sorting 2-21
Substitution Variables 2-22
Using the & Substitution Variable 2-24
Character and Date Values with Substitution Variables 2-26
Specifying Column Names, Expressions, and Text 2-27
Using the && Substitution Variable 2-28
Using the iSQL*Plus DEFINE Command 2-29
Using the VERIFY Command 2-30
Summary 2-31
Practice 2: Overview 2-32

iv

3

Using Single-Row Functions to Customize Output
Objectives 3-2
SQL Functions 3-3
Two Types of SQL Functions 3-4
Single-Row Functions 3-5
Character Functions 3-7
Case-Manipulation Functions 3-9
Using Case-Manipulation Functions 3-10
Character-Manipulation Functions 3-11
Using the