addresslist.sql

来自「java+oracle 完成通讯录的增删改查」· SQL 代码 · 共 33 行

create  table AddressList(
id number(20) primary key,
name varchar2(20),
phone varchar2(20),
address varchar2(50),
qq number(20),
email varchar2(50)
);



insert into AddressList values(1002,'左刚','010-26395398','北京',3663986,'[e-mail]');

insert into AddressList values(1003,'王东','0531-26395398','济南',6932561,'[e-mail]');
insert into AddressList values(1004,'james','[phone]','New York',336523612,'[e-mail]');
insert into AddressList values(1005,'陆框','021-25696385','上海',25639874,'[e-mail]');
insert into AddressList values(1006,'螃蟹','0532-26395398','青岛',26548621,'[e-mail]');
insert into AddressList values(1007,'海龙','0534-8888888','德州',55585792,'[e-mail]');
insert into AddressList values(1008,'边冬学','0755-6666666','深圳',35697421,'[e-mail]');
insert into AddressList values(1009,'scofiled','[phone]','Tokyo',56418213,'[e-mail]');

create table login_user(
userid number(20) primary key,
username varchar2(20),
userpwd varchar2(20)
);
insert into login_user values(01,'scott','tiger');
insert into login_user values(02,'java','oralce');

create sequence seq_list start with 1;

commit;