这个建表的语句怎么总是报错，提示缺少右括号？应该怎么改？

毛病出现在这个字段上，
是否为应届毕业生 GARD SMALLINT 2
建表语句create table NTB_EMPLOYEEPLAN (
   PK_EMPLOYEEPLAN         CHAR(20)                        not null
         /*要员计划表主键*/,
   PK_BUDGET_YEAR          CHAR(4)                         not null
         /*预算年度*/,
   PK_DEPTDOC              VARCHAR2(40)                    not null
         /*部门编码*/,
   PK_COST_CENTER          CHAR(20)                        not null
         /*成本中心编码*/,
   PK_POSITION             VARCHAR2(48)                    not null      
         /*职位编码*/,
   PK_LEVEL                CHAR(20)                        not null
         /*级别编码*/,      
   PERSON_COUNT            DECIMAL(8)                        
         /*人数*/,
   GARD                    SMALLINT(2)                         
         /*是否为应届毕业生*/,
   PLAN_CHECKIN_TIME       CHAR(6)                         
         /*计划到职时间*/,
   PLAN_PAY                DECIMAL(8)                       
         /*预计合同工资*/,
   ADD_REASON              VARCHAR2(50)                       
         /*增员理由*/,
   DELETE_FLAG             SMALLINT(2)                        
         /*删除标志*/,
   groupdef1            VARCHAR2(128)                   
         /*集团自定义1*/,
   groupdef2            VARCHAR2(128)                   
         /*集团自定义2*/,
   groupdef3            VARCHAR2(128)                   
         /*集团自定义3*/,
   groupdef4            VARCHAR2(128)                   
         /*集团自定义4*/,
   groupdef5            VARCHAR2(128)                   
         /*集团自定义5*/,
   groupdef6            VARCHAR2(128)                   
         /*集团自定义6*/,
   groupdef7            VARCHAR2(128)                   
         /*集团自定义7*/,
   groupdef8            VARCHAR2(128)                   
         /*集团自定义8*/,
   groupdef9            VARCHAR2(128)                   
         /*集团自定义9*/,
   groupdef10           VARCHAR2(128)                   
         /*集团自定义10*/,
   corpdef1             VARCHAR2(128)                   
         /*公司自定义1*/,
   corpdef2             VARCHAR2(128)                   
         /*公司自定义2*/,
   corpdef3             VARCHAR2(128)                   
         /*公司自定义3*/,
   corpdef4             VARCHAR2(128)                   
         /*公司自定义4*/,
   corpdef5             VARCHAR2(128)                   
         /*公司自定义5*/,
   corpdef6             VARCHAR2(128)                   
         /*公司自定义6*/,
   corpdef7             VARCHAR2(128)                   
         /*公司自定义7*/,
   corpdef8             VARCHAR2(128)                   
         /*公司自定义8*/,
   corpdef9             VARCHAR2(128)                   
         /*公司自定义9*/,
   corpdef10            VARCHAR2(128)                   
         /*公司自定义10*/,
   constraint PK_NTB_EMPLOYEEPLAN primary key (PK_EMPLOYEEPLAN),
   ts                   char(19)                       default to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'),
   dr                   number(10)                     default 0
)

解决方案 »

  1.   

    SMALLINT(2) 这个有必要指定长度吗，去掉试一下看看
      

  2.   

    oracle 只有int 或者用number(2)
      

  3.   

    SQL> create table ta(a1 smallint);Table created.Elapsed: 00:00:00.07
    SQL> desc ta
     Name                                                              Null?    Type
     ----------------------------------------------------------------- -------- ----------------------------
     A1                                                                         NUMBER(38)