在創建以下表的時候出現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);

?

?總結一下，但凡出現這個錯誤，應該就是語句中有錯的字母所導致的。。。

轉載于:https://www.cnblogs.com/han1028/archive/2010/04/23/1718540.html

總結

以上是生活随笔為你收集整理的ORA-00907：缺少右括号的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。