Adding Data to a Table

Previous

Next

You can add (or insert) a row of data to a table with Object Browser.

To add data to a table:

1. Log in to the Database Home Page. See "Logging in to the Database Home Page".

2. On the Database Home Page, click the Object Browser icon.

3. In the Object list, select Tables then click the personal_info table that you previously created.

4. Click Data.

5. Click the Insert Row button.

6. On the Create Row page, enter the following values:

   employee_id: 142

   birth_date: 01-SEP-65

   social_security_id: 555-11-4444

   marital_status: Married

   dependents_claimed: 4

   contact_name: Marilyn Davies

   contact_phone: 15552229999

   contact_email: marilyn.davies@mycompany.com

   Note that when you add the data to the personal_info table, the values must conform to any constraints on the table. For example, the contact_email value must be 40 characters or less and the employee_id value must match a value in the employee_id column of the employees table. If data is entered that violates any constraint, then an error displays when you attempt to create a row.

7. Click the Create and Create Another button to insert the row of data and create another row in the table.

8. In the Create Row page, enter the following values:

   employee_id: 143

   birth_date: 01-MAR-72

   social_security_id: 555-77-4444

   marital_status: Single

   dependents_claimed: 1

   contact_name: Carolyn Matos

   contact_phone: 15553338888

   contact_email: carolyn.matos@myinternet.com

9. Click the Create button to insert the row of data.