Oracle数据库常用语句

--用户表
create table shopusers(
id number primary key,
name varchar2(50) not null,
pwd varchar2(50) not null,
email varchar2(100) not null,
tel varchar(20) not null,
grade number(2) default 1 not null
)

insert into shopusers values(100,'张三','123','[e-mail]','1234567',1);
insert into shopusers values(101,'李四','123','[e-mail]','1234567',1);

--商品表
create table shopbook(
id number primary key,
name varchar2(50) not null,
author varchar2(100) not null,
publishHouse varchar2(100) not null,
price number not null,
nums number default 1000 not null
)

--创建序列
create sequence shopbook_seq
start with 1
increment by 1
minvalue 1
maxvalue 99999
nocycle
nocache

insert into shopbook values(shopbook_seq.nextval ,'java基础','张三','安庆大学出版社',100,1000);
insert into shopbook values(shopbook_seq.nextval,'jsp基础','周瑜','清华大学出版社',130,1000);
insert into shopbook values(shopbook_seq.nextval,'j2ee基础','陈六','河海大学出版社',60,1000);