Tutorial: Viewing EMPLOYEES Table Properties and Data

This tutorial shows how to use SQL Developer to view the properties and data of the EMPLOYEES table in the HR schema, if you are browsing the HR schema.

If you are not browsing the HR schema, follow the instructions in "Tutorial: Viewing HR Schema Objects" and then return to this topic.

To view the properties and data of the EMPLOYEES table:

1. In the Connections pane, expand Tables.

   Under Tables, a list of the tables in the HR schema appears.

2. Select the table EMPLOYEES.

   In the right frame of the Oracle SQL Developer window, in the Columns pane, a list of all columns of this table appears. To the right of each column are its properties—name, data type, and so on. (To see all column properties, move the horizontal scroll bar to the right.)

3. In the right frame, click the tab Data.

   The Data pane appears, showing a numbered list of all records in this table. (To see more records, move the vertical scroll bar down. To see more columns of the records, move the horizontal scroll bar to the right.)

4. In the right frame, click the tab Constraints.

   The Constraints pane appears, showing a list of all constraints on this table. To the right of each constraint are its properties—name, type, search condition, and so on. (To see all constraint properties, move the horizontal scroll bar to the right.)

5. Explore the other properties by clicking on the appropriate tabs.