Oracle Database/Restricting and Sorting Data

Limiting the rows that are retrieved by a query

 * Write queries that contain a WHERE clause to limit the output retrieved
 * Character strings and date values are enclosed with single quote
 * Character values are case-sensitive and date values are format-sensitive
 * The default date display format is DD-MON-YY
 * An alias cannot be used in the WHERE clause
 * List the comparison operators and logical operators that are used in a WHERE clause


 * Describe the rules of precedence for comparison and logical operators

Sorting the rows that are retrieved by a query
* The default sort order is ascending * Null values are displayed last for ascending sequences and first for descending sequence * You can also sort by a column that is not in the SELECT list
 * Write queries that contain an ORDER BY clause sort the output of a SELECT statement
 * Sort output in descending and ascending order

Using ampersand substitution to restrict and sort output at runtime
Use substitution variables to:
 * Temporarily store values with single-ampersand (&) and double-ampersand (&&) substitution

Use substitution variables to supplement the following:
 * WHERE conditions
 * ORDER BY clauses
 * Column expressions
 * Table names
 * Entire SELECT statements