3 Exploring Oracle Database with SQL Developer

Tutorial: Viewing HR Schema Objects

This tutorial shows how to use SQL Developer to view the objects that belong to the HR schema. This is called browsing the HR schema.

TDDDG125To browse the HR schema:

1. In the navigation frame, click the tab Connections.

   The Connections pane shows the hr_conn icon. To the left of the icon is a plus sign (+).

   
   Description of the illustration plussign.gif
   
   

2. Click the plus sign.

   If you are not connected to the database, the Connection Information window opens. If you are connected to the database, the hr_conn information expands (see the information that follows "Click OK" in step 3).

3. If the Connection Information window opens:

   1. In the User Name field, enter hr.

   2. In the Password field, enter the password for the user hr.

   3. Click OK.

   The hr_conn information expands: The plus sign becomes a minus sign, and under the hr_conn icon, a list of schema object types appears—Tables, Views, Indexes, and so on. (If you click the minus sign, the hr_conn information collapses: The minus sign becomes a plus sign, and the list disappears.)

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.

TDDDG126To 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.