田粟.txt

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

1，创建一个商品表 和 种类表；要求用到五个约束
create table sp(spid int,spname varchar2(20),spkindid int,spprice number);
create table kind(kindid int,kindname varchar2(20));
2，对刚才创建的商品表的列进行增，删，改操作，三个操作每个操作都有
drop table sp;

tra

rename  kind to kind20;

alter table sp add spdate date; 

alter table sp modify (spname not null);

alter table sp add constraint pk_sp_id primary key(spid);

alter table kind add constriant pk_kd_id primary key 
(kindid);

alter table kind add constraint fk_sp_kdid_spkdid foreign key(kindid) references sp(spid);

alter table sp add constraint ck_sp_spprice check
(spprice>0);

alter table kind add constraint un_kd_kname unique(kindname);