Table: Modifying

create table employee

(employee_id number,

first_name varchar2(50) ,

middle_initial varchar2(50),

last_name varchar2(50),

ssn number,

address varchar2(200)

);

alter table employee

add (

division varchar2(50)

);