-- g 商品表 create table g (gid number, gname varchar2(20), cnt number );
insert into g values (seq1.nextval,'牛',10); insert into g values (seq1.nextval,'马',8); insert into g values (seq1.nextval,'狼',7); insert into g values (seq1.nextval,'猫',6);
-- o 订单表 create table o ( oid number, gid number, much number );