Chapter 2: Retrieving Information from Database Tables

Overview

In this chapter, you will

• Retrieve information from one or more database tables using SELECT statements.

• Use arithmetic expressions to perform calculations.

• Filter rows to just those you are interested in using a WHERE clause.

• Sort the rows retrieved from a table.

The examples in this section use SQL*Plus and the store schema that you, or your DBA, should already have created in the previous chapter. If you want to follow along with the examples, you should start up SQL*Plus and enter store as the user name along with the password of store_password .