There are three steps to go through to extend the data in a table. First, you have to expand the structure of the table. Next, you will have to get the customer data into the newly expanded table with an SQL script. The final step will be to quickly create some pages to maintain this data and add it to the list of maintenance pages you created in the last chapter.
Try It Out: Adding Columns to an Existing Table
You begin the process by adding more columns to the CUSTOMERS table.
You can see that the CUSTOMERS table you created has just two columns. You have to add more columns to hold additional information about your customers.
On this page, you have to add a name for your new column, and make sure that the Type is appropriate for the data you will be storing in the column. You can also indicate that the column may or may not contain data by leaving the Nullable value to NULL.
The Oracle database always stores VARCHAR2 columns as variable length columns, so the Length specification does not ...