Viewing Table Data

Besides viewing table names and table definitions, you can view the data stored in the table, and the SQL statement used to display the data. You can also change the SQL statement to alter the results set.

To view table data:

1. Search for a table as described in "Viewing Tables". For example, search for the tables in the hr schema.

2. Select the table that contains the data.

   For example, select employees.

3. In the Actions list, select View Data, and then click Go.

   The View Data for Table page appears.

   The Query field displays the SQL query that was run to view the data for the table. The Result section shows the data in the table. You may have to use the horizontal scroll bar at the bottom of the page to view all columns.

4. (Optional) Click a column name to sort the data by that column.

5. (Optional) Click Refine Query to change the query and redisplay the data.

   The Refine Query for Table page appears. This page enables you to select the columns to display. It also enables you to specify a WHERE clause for the SQL SELECT statement to limit the results.

You can also write and submit your own SQL SELECT statement to see the contents of a table. You can run SQL statements by starting a SQL Worksheet session in Database Control. To do so, click SQL Worksheet in the Related Links section of the Database Home page.

A detailed description of the SELECT statement is in Oracle Database SQL Language Reference.