Question

oracle选项缺失或无效

--用户表
create table login
(
username varchar2(15) primary key,
password varchar2(15),
email varchar2(20),
tel varchar2(15),
useridcar varchar2(20),
droit int default 0
)
insert into login values('admin','admin','QQ:810730514','131-99999999','222401999999999999',1);
insert into login values('admin1','admin1','admin1@sina.com','131-00000000','222400000000000000',0);
insert into login values('admin2','admin2','admin2@sina.com','131-11111111','222401111111111111',0);
insert into login values('admin3','admin3','admin3@sina.com','131-22222222','222401222222222222',0);
insert into login values('admin4','admin4','admin4@sina.com','131-33333333','222401333333333333',0);
insert into login values('admin5','admin5','admin5@sina.com','131-44444444','222401444444444444',0);
insert into login values('admin6','admin6','admin6@sina.com','131-66666666','222401666666666666',0);
insert into login values('admin7','admin7','admin7@sina.com','131-77777777','222401777777777777',0);
commit;

Answer 1

应该是表名不能用login，关键字不能做表名