Viewing Table Data

Besides viewing table names and table definitions in SQL Developer, 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:

In SQL Developer, search for a table as described in "Viewing Tables". For example, search for the tables in the HR schema.
Select the table that contains the data.

For example, select countries.

A tab with the table name appears in the object pane, with the Columns subtab displayed.
In the object pane, click the Data subtab.

The data for the table appears on the Data subtab.

Description of the illustration sqld_view_table_data.gif
(Optional) Click a column name to sort the data by that column.
(Optional) Click the SQL subtab to view the SQL statement that defines the table.

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 SQL Developer. To do so, from the Tools menu, select SQL Worksheet.

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