plsql建表时提示ORA-00907:缺失右括号

Question

create table AMOUNT_LIMIT_CONFIG
(
id VARCHAR2(255) not null,
channelNo VARCHAR2(255) comment '渠道',
cpId VARCHAR2(255) comment '产品',
amountLimit VARCHAR2(255) comment '单户金额阀值'
)

Answer 1

注释拎出去试试

CREATE TABLE AMOUNT_LIMIT_CONFIG
(
  id VARCHAR2(255) NOT NULL,
  channelNo VARCHAR2(255) ,
  cpId VARCHAR2(255)  ,
  amountLimit VARCHAR2(255)  
);
COMMENT on column AMOUNT_LIMIT_CONFIG.channelNo is '渠道';
COMMENT on column AMOUNT_LIMIT_CONFIG.cpId is '产品';
COMMENT on column AMOUNT_LIMIT_CONFIG.amountLimit is '单户金额阀值';