Modifying a Column In a Table

Previous
Previous
Next
Next

You can use Object Browser to modify a column in a table.

To modify a column in 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 and then click the personal_info table that you previously created.

  4. Click Modify Column.

  5. Select the contact_email column. Change the datatype to VARCHAR2 with a length of 40. Change the column to be NOT NULL.

  6. Click the Next button.

  7. Click the Finish button to complete the action.