Question

oracle中设置主键时总是报出ORA-00904:标识符无效的错误。

-- Create table
create table BRANCH
(
BRANCHID NUMBER(4),
BRANCHNAME VARCHAR2(50),
BRANCHSHORTNAME VARCHAR2(50),
PRINCIPALUSER VARCHAR2(50) not null,
CONNECTTELNO VARCHAR2(50) not null,
CONNECTMOBILETELNO VARCHAR2(20) not null,
FAXES VARCHAR2(20) not null
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Add comments to the columns
comment on column BRANCH.BRANCHID
is '机构Id';
comment on column BRANCH.BRANCHNAME
is '机构名称';
comment on column BRANCH.BRANCHSHORTNAME
is '简称';
comment on column BRANCH.PRINCIPALUSER
is '负责人姓名';
comment on column BRANCH.CONNECTTELNO
is '联系电话';
comment on column BRANCH.CONNECTMOBILETELNO
is '手机';
comment on column BRANCH.FAXES
is '传真';
这是我的表的sql语句，然后我要把我的BRANCHID设置为主键时报出了ORA-009004:标识符无效的错误，后面还紧跟着这段代码：-- Create/Recreate primary, unique and foreign key constraints
alter table BRANCH
add constraint PB-BRANCHID primary key (BRANCHID);

Answer 1

不能用 减号 换成下划线 PB-BRANCHID 换成

PB_BRANCHID