Your browser does not support JavaScript. This help page requires JavaScript to render correctly. Tutorial: Changing Data in Tables in the Data Pane
Skip Headers
Previous
Previous
 
Next
Next

Tutorial: Changing Data in Tables in the Data Pane

This tutorial shows how to change three of the WEIGHT values in the PERFORMANCE_PARTS table (populated in "Tutorial: Adding Rows to Tables with the Insert Row Tool") in the Data pane.

To change data in the PERFORMANCE_PARTS table using the Data pane:

  1. On the Connections tab, expand hr_conn.

    Under the hr_conn icon, a list of schema object types appears.

  2. Expand Tables.

    A list of tables appears.

  3. Select PERFORMANCE_PARTS.

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

    The Data pane appears, showing the rows of the PERFORMANCE_PARTS table.

  5. In the row where NAME is Workload Management:

    1. Click the WEIGHT value.

    2. Enter the value 0.3.

    3. Press the key Enter.

  6. In the row where NAME is Building Relationships:

    1. Click the WEIGHT value.

    2. Enter the value 0.15.

    3. Press the key Enter.

  7. In the row where NAME is Customer Focus:

    1. Click the WEIGHT value.

    2. Enter the value 0.15.

    3. Press the key Enter.

  8. Click the icon Commit Changes.

    This icon is a picture of a data drum with a green check mark in the lower right corner.

    Under the Data pane is the Data Editor Log pane.

  9. Check the Data Editor Log pane for the message "Commit Successful".

  10. Check the new data in the Data Pane.

Related Topics

About the UPDATE Statement

Creating and Managing Tables