create table member (
mmbnumb number(4,0) constraint mmbnumb_not_null not null
constraint mmbnumb_pk primary key check (mmbnumb > 0),
mmbname varchar2(20) constraint mmbname_not_null not null,
mmbaddr varchar2(12) constraint mmbaddr_not_null not null,
mmbcity varchar2(10) constraint mmbcity_not_null not null,
mmbst char(2) constraint mmbst_not_null not null,
numrent number(4,0) constraint numrent_not_null not null,
bonus number(2,0) constraint bonus_not_null not null,
joindate date );

prompt Created table member;

insert into member values
(1, 'Allen, Donna', '21 Wilson', 'Carson', 'In', 2, 0,
to_date('05/25/95', 'mm/dd/yy'));
insert into member values
(2, 'Peterson, Mark', '215 Raymond', 'Cedar', 'In', 14, 1, to_date('02,20,94', 'mm/dd/yy'));
insert into member values
(3, 'Sanchez, Miquel', '47 Chipwood', 'Mantin', 'Il', 22, 0, to_date('06,14,94', 'mm/dd/yy'));
insert into member values
(4, 'Tran, Thanh', '108 College', 'Carson', 'In', 3, 0,to_date('07/03/95', 'mm/dd/yy'));
insert into member values
(5, 'Roberts, Terry', '602 Bridge', 'Hudson', 'Mi', 1, 0,to_date('11,16,94', 'mm/dd/yy'));
insert into member values
(6, 'MacDonald, Greg', '19 Oak', 'Carson', 'In', 11, 1,to_date('01,29,95', 'mm/dd/yy'));
insert into member values
(7, 'VanderJagt, Neal', '12 Bishop', 'Mantin', 'Il', 19,2,to_date('08,11,94', 'mm/dd/yy'));
insert into member values
(8, 'Shippers, John', '208 Grayton', 'Cedar', 'In', 6,1,to_date('09,02,95', 'mm/dd/yy'));
insert into member values
(9, 'Franklin, Trudy', '103 Bedford', 'Breook', 'Mi', 27, 3,to_date('12,13,94', 'mm/dd/yy'));
insert into member values
(10, 'Stein, Shelly', '82 Harcourt', 'Hudson', 'Mi', 4, 0,to_date('06,21,95', 'mm/dd/yy'));