Question

oracle建表的报错,这个sql语句错在哪里了,求指教

说是没有右括号什么的.

create table DeptInfo
(Dept_id integer(2) not null,
Dept_name nvarchar2(20) not null,
primary key(Dept_id)
)

create table PermInfo
(Perm_id integer(2) not null,
Perm_name nvarchar(20) not null,
primary key(Perm_id)
)

create table NameInfo
(User_name nvarchar2(100) not null,
User_psw nvarchar2(100) not null,
Dept_id integer(2) not null,
Perm_id integer(2) not null,
primary key(User_name),
foreign key(Dept_id) references DeptInfo(Dept_id),
foreign key(Perm_id) references PermInfo(Perm_id)
)

create table UserInfo
(User_id integer(10) not null,
User_name nvarchar2(100) not null,
log_time Date,
out_time Date,
Cdao_flag char(2) not null,
Ztui_flag char(2) not null,
Qqin_flag char(2) not null,
primary key(User_id),
foreign key(User_name) references NameInfo(User_name)
)
错误指向 integer(2)这里,不能这么写么,新手,求帮忙.

Answer 1

不能 你可以写 number(2)

Answer 2

改成 number(2)

Answer 3

直接写integer，不加精度