drop table customer2;

create table customer2 (
  SSN varchar2(9),
  lastNAme varchar2(20),
  firstname varchar2(20),
  address1 varchar2 (20),
  address2 varchar2(20),
  city varchar2(10),
  state varchar2(10),
  zipcode varchar2(5),
  savingsbalance number(10) ,
  checkingbalance number(10) );

insert into customer2 values ('123456789', 'Smith', 'Rob', '1111', 'First Street', 'San Jose', 'CA', '12345', 5123, 1234);

commit;
