Oracle Add Column

The Oracle Add Column – allow you to add new columns to existing tables.

Oracle Add Column

Alter table contracts 
add approve varchar2(3);

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

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