Example: Adding Table Columns

In this example, you add columns to the purchase_orders table that you created previously in "Example: Creating a Table". The two new columns are named po_date_received and po_requestor_name.

To add columns to the PURCHASE_ORDERS table:

1. Go to the Database Home page, logging in as user nick or as user SYSTEM.

   See "Accessing the Database Home Page".

2. At the top of the page, click Schema to view the Schema subpage.

3. In the Database Objects section, click Tables.

   The Tables page appears.

4. In the Schema field, enter nick, and then click Go.

   All tables owned by user nick are displayed.

5. Select the PURCHASE_ORDERS table, and then click Edit.

   The Edit Table page appears.

6. In the Columns section, in the first available row, enter the following information about the new po_date_received column:

   Field Name	Value
   Name	PO_DATE_RECEIVED
   Data Type	DATE

   
   

   You can leave Size, Scale, Not NULL, and Default Value blank.

7. In the next available row, enter the following information about the new po_requestor_name column:

   Field Name	Value
   Name	PO_REQUESTOR_NAME
   Data Type	VARCHAR2
   Size	40

   
   

   You can leave Scale, Not NULL, and Default Value blank.

8. Click Apply.

   An update message appears indicating that the table has been modified successfully.