Tutorial: Adding Rows to Tables with the Insert Row Tool

This tutorial shows how to use the Insert Row tool to add six populated rows to the PERFORMANCE_PARTS table (created in "Tutorial: Creating a Table with the Create Table Tool").

To add rows to the PERFORMANCE_PARTS table using the Insert Row tool:

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 names of the columns of the PERFORMANCE_PARTS table and no rows.

5. In the Data pane, click the icon Insert Row.

   A new row appears, with empty columns.

6. Click the cell under the column heading PERFORMANCE_ID.

7. Type WM.

   The value of PERFORMANCE_ID is now WM.

8. Either press the key Tab or click the cell under the column heading NAME.

9. Type Workload Management.

   The value of NAME is now Workload Management.

10. Either press the key Tab or click the cell under the column heading WEIGHT.

11. Type 0.2.

12. Press the key Enter.

    The value of WEIGHT is now 0.2.

13. Add and populate a second row by repeating steps 5 through 12 with these values:

    • For PERFORMANCE_ID, type BR.

    • For NAME, type Building Relationships.

    • For WEIGHT, type 0.2.

14. Add and populate a third row by repeating steps 5 through 12 with these values:

    • For PERFORMANCE_ID, type CF.

    • For NAME, type Customer Focus.

    • For WEIGHT, type 0.2.

15. Add and populate a fourth row by repeating steps 5 through 12 with these values:

    • For PERFORMANCE_ID, type CM.

    • For NAME, type Communication.

    • For WEIGHT, type 0.2.

16. Add and populate a fifth row by repeating steps 5 through 12 with these values:

    • For PERFORMANCE_ID, type TW.

    • For NAME, type Teamwork.

    • For WEIGHT, type 0.2.

17. Add and populate a sixth row by repeating steps 5 through 12, using these values:

    • For PERFORMANCE_ID, type RO.

    • For NAME, type Results Orientation.

    • For WEIGHT, type 0.2.

18. Click the icon Commit Changes.

    Under the Data pane is the Data Editor Log pane.

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

20. Check the new rows in the Data Pane.