今天在oracle中使用脚本建表时,出错了,一直没弄清是什么原因,是字段太多并且都使用比较大的varchar类型还是使用了clob类型?刚使用oracle不久,请高人指点,建表语句
/*==============================================================*/
/* Table: "YJ_SC_EnterPriseInfo" */
/*==============================================================*/
create table "YJ_SC_EnterPriseInfo" (
"ApplyID" varchar(36) not null,
"EnterpriseID" varchar(36) not null,
"ApplyType" int not null,
"Applicant" varchar(30),
"EnterpriseName" varchar(100),
"RegisteCapital" number(18,4),
"RegisteAddress" varchar(150),
"ParentUnit" varchar(150),
"EconomicNature" varchar(100),
"BusinessScope" varchar(500),
"OperationWay" int,
"LegalPerson" varchar(200),
"DutyPerson" varchar(200),
"QualityPerson" varchar(200),
"QualityOrgPerson" varchar(200),
"EnterpriseType" int,
"ParentStore" varchar(150),
"Contact" varchar(40),
"ContactNumber" varchar(60),
"Fax" varchar(60),
"PostCode" varchar(10),
"WorkersCount" int,
"QualityWorkersCount" int,
"LicensedPhaCount" int,
"MainPhaCount" int,
"SubMainPhaCount" int,
"LeaderPhaCount" int,
"PhaCount" int,
"PhaWorkerCount" int,
"SubPhaCount" int,
"BusinessArea" number(18,4),
"SubBusinessArea" number(18,4),
"OfficeArea" number(18,4),
"AreaNote" varchar(300),
"WareHouseArea" number(18,4),
"SubCoolWareHouseArea" number(18,4),
"ProWareHouseArea" number(18,4),
"CoolWareHouseArea" number(18,4),
"NormalWareHouseArea" number(18,4),
"DistributionArea" number(18,4),
"LastYearSale" NUMBER(18.4),
"EnterpriseInstr" CLOB,
"EnterpriseTypeStr" VARCHAR(100),
"WareHouseNote" VARCHAR(200),
"TheStatus" int,
"RecTime" DATE,
"TheNote" VARCHAR(200),
constraint PK_YJ_SC_ENTERPRISEINFO primary key ("ApplyID")
);