张杨.txt

关于oracle和sql的书籍和ppt教程,非常好,本人珍藏品

1，创建一个商品表 和 种类表；要求用到五个约束
2，对刚才创建的商品表的列进行增，删，改操作，三个操作每个操作都有
create table classtable
  (classid number,
   name varchar2(10) not null,
   constraint pk_classid primary key(classid)
   );
  
  
  create table shoptable 
  (   shoppid number(4),
      name varchar2(10),
      price number,
      classid number, 
      constraint pr_id primary key(shoppid),
      constraint ch_pr check(price>0),
      constraint fk_classid foreign key(classid) references classtable(classid)
    );
/*insert into classtable values(10,'食品类');
insert into classtable values(20,'日用品类');
insert into classtable values(30,'电器类');
insert into classtable values(40,'饮料类');
insert into shoptable values(01,'灯泡',10,30);
insert into shoptable values(02,'饼干',23,10);
insert into shoptable values(03,'洗发水',50,20);
insert into shoptable values(04,'绿茶',1,40);
alter table shoptable add (address varchar2(10));
alter table shoptable drop(address ) ; 
update classtable set classid=50 where classid=10;--违反完整约束条件 (SCOTT.FK_CLASSID) - 已找到子记录
delete from classtable where classid=10;--违反完整约束条件 (SCOTT.FK_CLASSID) - 已找到子记录*/
delete from shoptable where shoppid=04;
insert into shoptable values(04,'绿茶',1,40);