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.

To 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 (+).

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