Viewing Your Database Objects

Review the objects you just created by going to Object Browser. Object Browser enables you to browse, create, and edit objects in your database.

To view the objects:

1. On the Workspace home page, click SQL Workshop.

2. Click Object Browser.

   Object Browser appears.

   
   Description of the illustration o_brws_oehr.gif
   
   

   Object Browser is divided into two sections:

   • Object Selection pane displays on the left side of the Object Browser page and lists database objects of a selected type within the current schema.

   • Detail pane displays to the right of the page and displays detailed information about a selected object.

3. From the list in the Object Selection pane on the left, select Tables.

   The Detail pane lists the tables in your current schema.

4. In the Object Selection pane, click OEHR_EMPLOYEES from the list.

   The Detail pane shows details about the table.

5. Click the Data tab at the top of the Details pane.

   The data in the OEHR_EMPLOYEES table appears. Note that other tabs show additional details about the object you select.

6. To search for an object name, enter a case-insensitive term in the Search field.

   
   Description of the illustration o_brws_srch_oehr.gif
   
   

7. To view all objects, leave the Search field blank.