| Logging on to SQL*Plus |
|
|
Entering a Command |
| Using the SQL*Plus Editor |
| Retrieving Database Records
Using SQL: The Select, Where, and Order By Clauses |
|
|
Identifying Table and
Column Names |
|
|
Components of a Simple
SELECT |
|
|
Examples of
Simple SELECT statements |
|
|
Creating Character Values in the SELECT
clause |
|
|
Computing Numeric Values in the SELECT
clause |
|
Limiting the Database Records Retrieved |
|
|
Evaluation Operators Used in the Where
Clause |
|
|
Using the Equal (=) and IS operators |
|
|
Using the Greater Than (>) and Less
Than (<) Operators |
|
|
Using the In Operator |
|
|
ANY, SOME, or ALL Keywords |
|
|
Using the Between Operator |
|
|
Using the LIKE Operator |
|
|
Using AND or OR to Document Multiple
Conditions |
|
|
Mixing AND and OR in the WHERE clause |
|
Ordering records |
|
|
Ascending/Descending Order |
|
|
Using Expression Numbers as the Names
of Sort Columns |
|
Printing the Results of Your Query |
|
|
|
