Oracle Lessons: Adding a New Column to a Table

	Adding a New Column to a Table

Description

The basic formula to add a new column to an existing table is:

ALTER TABLE TableName
ADD ColumnName Properties

The ColumnName factor is required. In fact, on the right side of the ADD keyword, define the column by its name and using all the options we reviewed for columns.

Here is an example:

SQL> CREATE TABLE StaffMembers(FullName NVARCHAR2(60));

Table created.

SQL> ALTER TABLE StaffMembers
  2  ADD Address NVARCHAR2(100);

Table altered.

SQL>