create table donor
(idno varchar(5),
name varchar2(15),
stadr varchar2(15),
city varchar2(10),
state varchar2(2),
zip varchar2(5),
datefst date,
yrgoal number(7,2),
contact varchar2(12));
insert into donor values('11111','Stephen Daniels','123 Elm St','Seekonk','MA','02345','03-JUL-98',500,'John Smith');
insert into donor values('12121','Jennifer Ames','24 Benefit St','Providence','RI','02045','24-MAY-97',400,'Susan Jones');
insert into donor values('22222','Carl Hersey','24 Benefit St','Providence','RI','02045','03-JAN-98',null,'Susan Jones');
insert into donor values('23456','Susan Ash','21 Main St','Fall River','MA','02720','04-MAR-92',100,'Amy Costa');
insert into donor values('33333','Nancy Taylor','26 Oak St','Fall River','MA','02720','04-MAR-92',50,'John Adams');
insert into donor values('34567','Robert Brooks','36 Pine St','Fall River','MA','02720','04-APR-98',50,'Amy Costa');
select * from donor;
create table donorbk as select * from donor;