商品销售数据库 1--用SQL建立三个表,须指出该表的实体完整性和参照完整性,对性别和年龄指出用户自定义的约束条件。(性别分成男女,年龄从10到100)。 --顾客表的数据用插入语句输入数据,其它两表可用任意方式输入数据。 create table Article( goodsno varchar2(4) constraint pk_goodsno primary key, goodsname varchar2(16),--商品名 price number(8,2),--单价 goodsnum int --数量 ) drop table Article; insert into Article (goodsno,goodsname,price,goodsnum) values ('s001','计算机',5000,10); insert into Article (goodsno,goodsname,price,goodsnum) values ('s002','打印机',1000,12); insert into Article (goodsno,goodsname,price,goodsnum) values ('s003','洗衣机',800,10); insert into Article (goodsno,goodsname,price,goodsnum) values ('s004','电冰箱',1100,20); select* from Article; create table Customer( cno varchar2(4) constraint pk_cno primary key, cname varchar2(8) not null, csex varchar2(2) check (csex in('男','女')), cage int constraint c_cage check (cage between 10 and 100) ) drop table Customer; insert into Customer(cno,cname,csex,cage) values('G001','张三','男',29); insert into Customer(cno,cname,csex,cage) values('G002','李四','女',25); insert into Customer(cno,cname,csex,cage) values('G003','王五','女',31); insert into Customer(cno,cname,csex,cage) values('G004','赵六','男',25); insert into Customer(cno,cname,csex,cage) values('G005','小酒','女',20); insert into Customer(cno,cname,csex,cage) values('G006','小猪','女',22); select * from Customer; create table OrderItem( cno varchar2(4) constraint fk_manno references Customer(cno), goodsno varchar2(4) constraint fk_goodno references Article (goodsno), goodsnum int, --数量 buyprice number(8,2),--购买价 &nb
Oracle 查询 包括高级查询案例
最新推荐文章于 2025-07-05 16:07:35 发布