Add Column Examples

Example 1

Alter table contracts add approve varchar2(3);

Example 2

Alter table contracts
    add constraint ck_approve
      check (approve in ('YES', 'NO'));


Example 3

Alter table customers
    add (
      city varchar2(80),
      country varchar2(80)
    );