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')); |