
drop table sampleparts cascade constraints;
create table sampleparts(
  pno      number(5) not null primary key,
  pname    varchar2(30),
  qoh      integer check(qoh >= 0),
  listprice    number(6,2) check(listprice >= 0.00),
  reorderlevel   integer,
  reorderqty  integer,
  lastordered date);

insert into sampleparts values
  (10506,'Land Before Time I',200,19.99,220,100,'01-MARCH-2000');
insert into sampleparts values
  (10507,'Land Before Time II',156,14.99,215,89,'03-MARCH-2000');
insert into sampleparts values
  (10508,'Land Before Time III',190,19.99,220,55,'30-MAY-2001'); 
insert into sampleparts values
  (10509,'Land Before Time IV',60,19.99,120,55,'03-MARCH-2001');
insert into sampleparts values
  (10601,'Sleeping Beauty',300,24.99,300,55,'03-MARCH-2000');
insert into sampleparts values
  (10701,'When Harry Met Sally',120,19.99,30,55,'03-MARCH-2000');
insert into sampleparts values
  (10800,'Dirty Harry',140,14.99,230,55,'03-MARCH-2000');
insert into sampleparts values
  (10900,'Dr. Zhivago',100,24.99,30,55,'03-MARCH-2000');

column pname format a30
 
