|
This course provides information about using the SELECT statement and using the WHERE and ORDER BY clauses in Oracle9i SQL.
Objectives:
After completing this course, students will be able to:
- Use the WHERE clause to filter out rows from query results
- Format query results
- Use multiple filters in a query
- Query the DUAL table
- Sort query results using the ORDER BY clause
- Handle null values in query results
Topics:
- Using the WHERE clause
- Formatting query results
- Using multiple filters
- Dual and pseudocolumns
- Using the ORDER BY clause
- Sorting rules for null values
|
