使用create关键字创建
使用insert关键字添加信息
--商品列表
drop table Goods;
create table Goods(Gnum number primary key,Gname varchar2(50),Bname varchar2(30),Price number,Discount number, Remark varchar2(500));
insert into Goods values(01,'电视' , '海尔' , 3999 , 1,'高清晰,大屏幕,智能网络电视');
insert into Goods values(02,'冰箱' , '海尔' , 2999 , 1,'低电耗,强制冷,更节能且健康');
select *from Goods;
--会员信息表
create table VIP(Vnum number primary key,Name varchar2(20),Sex varchar2(5),Age date, Loc varchar2(500));
insert into VIP values(0001,'孙悟空' , '男' , to_date('1949-10-01','yyyy-mm-dd'),'花果山水帘洞');
insert into VIP values(0002,'猪八戒' , '男' , to_date('1999-11-11','yyyy-mm-dd'),'福陵山云栈洞');
select * from VIP;
--购物车列表
create table Cart(Vnum number,Gnum number,Price number,Count number, Pay number);
insert into Cart values(0001, 02, 2999 , 2 , 5998);
insert into Cart values(0002, 01, 3999 , 1 , 3999);
select *from Cart;
--登录信息表
create table Login(Vnum number ,Accnum number,PWord varchar2(20), Notice varchar2(500));
insert into Login values(0001, 201707150001, 'woshihuiyuan' , '密码为:我是会员');
insert into Login values(0002, 201707150002, 'woshivip' , '密码为:我是VIP');
select * from Login;