ORA-00907:缺少右括号
在创建以下表的时候出现ORA-00907:缺少右括号的错误,最后发现是字符串类型写错了,VARCHAR2写成了VARCAHR2,
/*==============================================================*/
/* DBMS name: ORACLE Version 9i2 */
/* Created on: 2010-4-23 12:28:27 */
/*==============================================================*/
alter table S_SHOUSHUYX
drop constraint FK_S_SHOUSH_REFERENCE_Y_BINGRE;
drop table S_SHOUSHUYX cascade constraints;
/*==============================================================*/
/* Table: S_SHOUSHUYX */
/*==============================================================*/
create table S_SHOUSHUYX (
SHOUSHUYXXXBH NUMBER(18) not null,
"BingRenBH" NUMBER(18),
QSZZ VARCAHR2(20),
QSZZQT VARCAHR2(50),
QSZZBM VARCAHR2(5),
QBSJ VARCAHR2(20),
GWYS VARCAHR2(20),
GWYSBM VARCAHR2(5),
TLBYSSQ VARCAHR2(20),
TLBYSSQBM VARCAHR2(5),
TLBYSSH VARCAHR2(20),
TLBYSSHBM VARCAHR2(5),
TLBYSDM VARCAHR2(20),
TLBYSDMBM VARCAHR2(5),
FS VARCAHR2(20),
FSBM VARCAHR2(5),
YGKZ VARCAHR2(20),
YGKZBM VARCAHR2(5),
ZD VARCAHR2(50),
SSFS VARCAHR2(20),
SSFSBM VARCAHR2(5),
BZ VARCAHR2(20),
BZBM VARCAHR2(5),
YXQCFW VARCAHR2(20),
YXQCFWBM VARCAHR2(5),
BP VARCAHR2(20),
BPBM VARCAHR2(5),
SZCLYG VARCAHR2(20),
SZCLYGBM VARCAHR2(5),
YXZD VARCAHR2(20),
YXZDBM VARCAHR2(5),
YSRZCPDSS VARCAHR2(20),
YSRZCPDSSBM VARCAHR2(5),
QSFW VARCAHR2(50),
QSFWBM VARCAHR2(5),
GZD VARCAHR2(20),
GZDBM VARCAHR2(5),
XGQC VARCAHR2(20),
XGQCBM VARCAHR2(5),
MJMQJ VARCAHR2(20),
MJMQJBM VARCAHR2(5),
SMACJ VARCAHR2(20),
SMACJBM VARCAHR2(5),
YCWH VARCAHR2(20),
YCWHBM VARCAHR2(5),
YCWHCL VARCAHR2(20),
YCWHCLBM VARCAHR2(5),
DCWH VARCAHR2(20),
DCWHBM VARCAHR2(5),
DCWHCL VARCAHR2(20),
DCWHCLBM VARCAHR2(5),
WCWH VARCAHR2(20),
WCWHBM VARCAHR2(5),
ZYGWYL VARCAHR2(20),
ZYGWYLBM VARCAHR2(5),
KCZL VARCAHR2(20),
KCZLBM VARCAHR2(5),
YLSL VARCAHR2(20),
YLSLBM VARCAHR2(5),
CXL VARCAHR2(20),
SXLRBC VARCAHR2(20),
SXJ VARCAHR2(20),
BFZ VARCAHR2(20),
BFZBM VARCAHR2(5),
ZCSS VARCAHR2(20),
ZCSSBM VARCAHR2(5),
SHSZYSSYQK VARCAHR2(20),
SHSZYSSYQKBM VARCAHR2(5),
SHSZYSSYQKSM VARCAHR2(100),
ZLBJW_AFP VARCAHR2(20),
ZLBJW_CA199 VARCAHR2(20),
ZLBJW_CA125 VARCAHR2(20),
ZLBJW_CEA VARCAHR2(20),
ZLBJW_TDB VARCAHR2(20),
HD_SQJH VARCAHR2(20),
HD_SQJHBM VARCAHR2(5),
HD_KSJHRQ VARCAHR2(20),
HD_JHCS VARCAHR2(20),
HD_SQZGSTB VARCAHR2(20),
HD_SQZGSDB VARCAHR2(20),
HD_JHTB VARCAHR2(20),
HD_JHDB VARCAHR2(20),
HD_JHTBDB VARCAHR2(20),
XQCT_CPEPTIDE VARCAHR2(20),
TNMFQ_T VARCAHR2(100),
TNMFQ_TBM VARCAHR2(5),
TNMFQ_N VARCAHR2(100),
TNMFQ_NBM VARCAHR2(5),
TNMFQ_M VARCAHR2(100),
TNMFQ_MBM VARCAHR2(5),
ZZFH VARCAHR2(20),
ZZFHBM VARCAHR2(5),
QY VARCAHR2(20),
QYBM VARCAHR2(5),
FQ VARCAHR2(20),
FQBM VARCAHR2(5),
"Histology_LX" VARCAHR2(50),
"Histology_LXBM" VARCAHR2(5),
"Histology_JJX" VARCAHR2(50),
"Histology_JJXBM" VARCAHR2(5),
"Histology_EX" VARCAHR2(50),
"Histology_EXBM" VARCAHR2(5),
"Histology_QT" VARCAHR2(50),
TP_BBWZ VARCAHR2(20),
TP_BZ VARCAHR2(400),
TP_BBWZBM VARCAHR2(5),
TP_BBWZHBQQ VARCAHR2(20),
TP_BBWZHBQQBM VARCAHR2(5),
constraint PK_S_SHOUSHUYX primary key (SHOUSHUYXXXBH)
);
comment on table S_SHOUSHUYX is
'胰腺手术登记表';
comment on column S_SHOUSHUYX.SHOUSHUYXXXBH is
'信息编码';
comment on column S_SHOUSHUYX."BingRenBH" is
'病人编号,记录顺序号,自动增长.';
comment on column S_SHOUSHUYX.QSZZ is
'起始症状';
comment on column S_SHOUSHUYX.QSZZQT is
'起始症状其它';
comment on column S_SHOUSHUYX.QSZZBM is
'起始症状编码';
comment on column S_SHOUSHUYX.QBSJ is
'起病时间(以星期计算)';
comment on column S_SHOUSHUYX.GWYS is
'高危因素';
comment on column S_SHOUSHUYX.GWYSBM is
'高危因素编码';
comment on column S_SHOUSHUYX.TLBYSSQ is
'糖尿病因素_术前';
comment on column S_SHOUSHUYX.TLBYSSQBM is
'糖尿病因素_术前编码';
comment on column S_SHOUSHUYX.TLBYSSH is
'糖尿病因素_术后';
comment on column S_SHOUSHUYX.TLBYSSHBM is
'糖尿病因素_术后编码';
comment on column S_SHOUSHUYX.TLBYSDM is
'糖尿病因素_DM';
comment on column S_SHOUSHUYX.TLBYSDMBM is
'糖尿病因素_DM编码';
comment on column S_SHOUSHUYX.FS is
'腹水';
comment on column S_SHOUSHUYX.FSBM is
'腹水编码';
comment on column S_SHOUSHUYX.YGKZ is
'胰管扩张';
comment on column S_SHOUSHUYX.YGKZBM is
'胰管扩张编码';
comment on column S_SHOUSHUYX.ZD is
'诊断';
comment on column S_SHOUSHUYX.SSFS is
'手术方式';
comment on column S_SHOUSHUYX.SSFSBM is
'手术方式编码';
comment on column S_SHOUSHUYX.BZ is
'病灶';
comment on column S_SHOUSHUYX.BZBM is
'病灶编码';
comment on column S_SHOUSHUYX.YXQCFW is
'胰腺切除范围';
comment on column S_SHOUSHUYX.YXQCFWBM is
'胰腺切除范围编码';
comment on column S_SHOUSHUYX.BP is
'保脾';
comment on column S_SHOUSHUYX.BPBM is
'保脾编码';
comment on column S_SHOUSHUYX.SZCLYG is
'术中测量胰管';
comment on column S_SHOUSHUYX.SZCLYGBM is
'术中测量胰管编码';
comment on column S_SHOUSHUYX.YXZD is
'胰腺质地';
comment on column S_SHOUSHUYX.YXZDBM is
'胰腺质地编码';
comment on column S_SHOUSHUYX.YSRZCPDSS is
'胰十二指肠PD术式';
comment on column S_SHOUSHUYX.YSRZCPDSSBM is
'胰十二指肠PD术式编码';
comment on column S_SHOUSHUYX.QSFW is
'清扫范围';
comment on column S_SHOUSHUYX.QSFWBM is
'清扫范围编码';
comment on column S_SHOUSHUYX.GZD is
'根冶度';
comment on column S_SHOUSHUYX.GZDBM is
'根冶度编码';
comment on column S_SHOUSHUYX.XGQC is
'血管切除';
comment on column S_SHOUSHUYX.XGQCBM is
'血管切除编码';
comment on column S_SHOUSHUYX.MJMQJ is
'门静脉重建';
comment on column S_SHOUSHUYX.MJMQJBM is
'门静脉重建编码';
comment on column S_SHOUSHUYX.SMACJ is
'SMA重建';
comment on column S_SHOUSHUYX.SMACJBM is
'SMA重建编码';
comment on column S_SHOUSHUYX.YCWH is
'胰肠吻合';
comment on column S_SHOUSHUYX.YCWHBM is
'胰肠吻合编码';
comment on column S_SHOUSHUYX.YCWHCL is
'胰肠吻合材料';
comment on column S_SHOUSHUYX.YCWHCLBM is
'材料编码';
comment on column S_SHOUSHUYX.DCWH is
'胆肠吻合';
comment on column S_SHOUSHUYX.DCWHBM is
'胆肠吻合编码';
comment on column S_SHOUSHUYX.DCWHCL is
'胆肠吻合材料';
comment on column S_SHOUSHUYX.DCWHCLBM is
'胆肠吻合材料编码';
comment on column S_SHOUSHUYX.WCWH is
'胃肠吻合';
comment on column S_SHOUSHUYX.WCWHBM is
'胃肠吻合编码';
comment on column S_SHOUSHUYX.ZYGWYL is
'主胰管外引流';
comment on column S_SHOUSHUYX.ZYGWYLBM is
'主胰管外引流编码';
comment on column S_SHOUSHUYX.KCZL is
'空肠造瘘';
comment on column S_SHOUSHUYX.KCZLBM is
'空肠造瘘编码';
comment on column S_SHOUSHUYX.YLSL is
'引流数量';
comment on column S_SHOUSHUYX.YLSLBM is
'引流数量编码';
comment on column S_SHOUSHUYX.CXL is
'出血量';
comment on column S_SHOUSHUYX.SXLRBC is
'输血量RBC';
comment on column S_SHOUSHUYX.SXJ is
'输血浆';
comment on column S_SHOUSHUYX.BFZ is
'并发症';
comment on column S_SHOUSHUYX.BFZBM is
'并发症编码';
comment on column S_SHOUSHUYX.ZCSS is
'再次手术';
comment on column S_SHOUSHUYX.ZCSSBM is
'再次手术编码';
comment on column S_SHOUSHUYX.SHSZYSSYQK is
'术后生长抑素使用情况';
comment on column S_SHOUSHUYX.SHSZYSSYQKBM is
'术后生长抑素使用情况编码';
comment on column S_SHOUSHUYX.SHSZYSSYQKSM is
'术后生长抑素使用情况说明';
comment on column S_SHOUSHUYX.ZLBJW_AFP is
'肿瘤标记物_AFP';
comment on column S_SHOUSHUYX.ZLBJW_CA199 is
'肿瘤标记物_CA199';
comment on column S_SHOUSHUYX.ZLBJW_CA125 is
'肿瘤标记物_CA125';
comment on column S_SHOUSHUYX.ZLBJW_CEA is
'肿瘤标记物_CEA';
comment on column S_SHOUSHUYX.ZLBJW_TDB is
'肿瘤标记物_铁蛋白';
comment on column S_SHOUSHUYX.HD_SQJH is
'黄疸_术前减黄';
comment on column S_SHOUSHUYX.HD_SQJHBM is
'黄疸_术前减黄编码';
comment on column S_SHOUSHUYX.HD_KSJHRQ is
'黄疸_开始减黄日期';
comment on column S_SHOUSHUYX.HD_JHCS is
'黄疸_减黄天数';
comment on column S_SHOUSHUYX.HD_SQZGSTB is
'黄疸_术前最高时TB';
comment on column S_SHOUSHUYX.HD_SQZGSDB is
'黄疸_术前最高时DB';
comment on column S_SHOUSHUYX.HD_JHTB is
'黄疸_减黄TB';
comment on column S_SHOUSHUYX.HD_JHDB is
'黄疸_减黄DB';
comment on column S_SHOUSHUYX.HD_JHTBDB is
'黄疸_减黄TB/DB';
comment on column S_SHOUSHUYX.XQCT_CPEPTIDE is
'血清C肽_C-peptide';
comment on column S_SHOUSHUYX.TNMFQ_T is
'TNM分期_T';
comment on column S_SHOUSHUYX.TNMFQ_TBM is
'TNM分期_T编码';
comment on column S_SHOUSHUYX.TNMFQ_N is
'TNM分期_N';
comment on column S_SHOUSHUYX.TNMFQ_NBM is
'TNM分期_N编码';
comment on column S_SHOUSHUYX.TNMFQ_M is
'TNM分期_M';
comment on column S_SHOUSHUYX.TNMFQ_MBM is
'TNM分期_M编码';
comment on column S_SHOUSHUYX.ZZFH is
'组织分化';
comment on column S_SHOUSHUYX.ZZFHBM is
'组织分化编码';
comment on column S_SHOUSHUYX.QY is
'切缘';
comment on column S_SHOUSHUYX.QYBM is
'切缘编码';
comment on column S_SHOUSHUYX.FQ is
'分期';
comment on column S_SHOUSHUYX.FQBM is
'分期编码';
comment on column S_SHOUSHUYX."Histology_LX" is
'Histology_良性';
comment on column S_SHOUSHUYX."Histology_LXBM" is
'Histology_良性编码';
comment on column S_SHOUSHUYX."Histology_JJX" is
'Histology_交界性';
comment on column S_SHOUSHUYX."Histology_JJXBM" is
'Histology_交界性编码';
comment on column S_SHOUSHUYX."Histology_EX" is
'Histology_恶性';
comment on column S_SHOUSHUYX."Histology_EXBM" is
'Histology_恶性编码';
comment on column S_SHOUSHUYX."Histology_QT" is
'Histology_其它';
comment on column S_SHOUSHUYX.TP_BBWZ is
'图片_病变位置';
comment on column S_SHOUSHUYX.TP_BZ is
'图片_备注';
comment on column S_SHOUSHUYX.TP_BBWZBM is
'图片_病变位置编码';
comment on column S_SHOUSHUYX.TP_BBWZHBQQ is
'图片_病变位置红笔圈出';
comment on column S_SHOUSHUYX.TP_BBWZHBQQBM is
'图片_病变位置红笔圈出编码';
alter table S_SHOUSHUYX
add constraint FK_S_SHOUSH_REFERENCE_Y_BINGRE foreign key ("BingRenBH")
references "Y_BingRenJBXX" (BINGRENBH);
总结一下,但凡出现这个错误,应该就是语句中有错的字母所导致的。。。
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步