Adding Data to a Table, Modifying, and Deleting

Creating and Using Tables

Creating and Using Database Objects 3-13

In the Confirmation window, click OK.

You have now created a check constraint on the

score

column of the

scores

table.

The following SQL statement was added to your table definition:

CONSTRAINT "SCORE_VALID" CHECK (score >=0 and score <=9) ENABLE

Adding Data to a Table, Modifying, and Deleting

You can use SQL Developer to enter data into tables, to edit, and to delete existing
data. The following tasks will show these processes for the

performance_parts

table.

To add data to a table using the SQL Developer interface:

Follow these steps to add rows of data to the

performance_parts

table

In the Connections navigation hierarchy, double-click the

performance_parts

table.

Click the Data tab in the

performance_parts

table display.

In the Data pane, click the New Record icon.