韩顺平-玩转Oracle10g实战教程全套PPT剖析.ppt

* * * 可以建表演示一下. * * 可以建表演示一下. * create table customer (customerId char(8) primary key, name varchar2(20) not null, address varchar2(30), email varchar2(30) unique, sex char(2) default 男 check (sex in(男,女)) , cardId char(18)) create table purchase (customerId char(8) references customer(customerid), goodsId char(8) references goods(goodsid), nums number(10) check (nums between 1 and 30), primary key (customerId,goodsId)) * alter table goods modify goodsName not null; alter table customer add constraint aaa unique(cardId); alter table customer add constraint aaabb check (address in(aaa,bbb));