程序,人生,思想,灵魂。

欢迎大家访问我的个人网站 萌萌的IT人

导航

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);

 

 总结一下,但凡出现这个错误,应该就是语句中有错的字母所导致的。。。

posted on   乔帮主  阅读(7107)  评论(0编辑  收藏  举报

努力加载评论中...
点击右上角即可分享
微信分享提示