Oracle Tutorial

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)
);