Skip Headers
Oracle® Database 2 Day Developer's Guide
11g Release 2 (11.2)

Part Number E10766-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

3 Exploring Oracle Database with SQL Developer

This chapter contains the following topics:

Note:

To do the tutorials in this document, you must be connected to Oracle Database as the user HR from SQL Developer. For instructions, see "Connecting to Oracle Database as User HR from 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.

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

    Description of plussign.gif follows
    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.)

See Also:

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.

See Also: