创建oracle表格及添加内容

来源：互联网发布：淘宝网评价管理网页. 编辑：程序博客网时间：2024/05/17 08:54

使用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;

阅读全文

1 0