Tutorial: Creating a Table with the Create Table Tool

This tutorial shows how to create the PERFORMANCE_PARTS table using the Create Table tool.

To create the PERFORMANCE_PARTS table using the Create Table tool:

1. On the Connections tab, expand hr_conn.

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

2. Right-click Tables.

   A list of choices appears.

3. Click New Table.

   The Create Table window opens, with default values for a new table, which has only one row.

4. For Schema, accept the default value, HR.

5. For Name, enter PERFORMANCE_PARTS.

6. In the default row:

   • For Column Name, enter PERFORMANCE_ID.

   • For Type, accept the default value, VARCHAR2.

   • For Size, enter 2.

   • For Not Null and Primary Key, accept the default values, deselected.

7. Click Add Column.

8. For Column Name, enter NAME.

9. For Type, enter VARCHAR2.

10. For Size, enter 80.

11. Click Add Column.

12. For Column Name, enter WEIGHT.

13. For Type, enter NUMBER.

14. Click OK.

    The table PERFORMANCE_PARTS is created. To see it, expand Tables in the navigation frame.