CREATE TABLE "CESHI_NOTE" ("ID" NVARCHAR2(36) NOT NULL ENABLE, "CREATE_BY" NVARCHAR2(50), "CREATE_TIME" DATE, "UPDATE_BY" NVARCHAR2(50), "UPDATE_TIME" DATE, "SYS_ORG_CODE" NVARCHAR2(64), "NAME" NVARCHAR2(32), "SEX" NVARCHAR2(32), "AGE" NUMBER(11, 0), "REMARK" NVARCHAR2(1000), "BIRTHDAY" DATE, "XIA_TIME" DATE, "SALARY" NUMBER(10, 3), "LOG_TXT" NCLOB, "POP_CC" NVARCHAR2(32), "USER_ID" NVARCHAR2(32), "DEP_ID" NVARCHAR2(32), "KAI_GUAN" NVARCHAR2(1), "FILE2" NVARCHAR2(300), "PIC" NVARCHAR2(300), "SHENGSHIQU" NVARCHAR2(32), "ACCC" NVARCHAR2(100), "DAA_TYPE" NVARCHAR2(32), "CCC" NVARCHAR2(32), "AAA" NVARCHAR2(32)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING NOCOMPRESS LOB ("LOG_TXT") STORE AS BASICFILE (TABLESPACE "USERS" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))
|
INSERT INTO "CESHI_NOTE" ("ID", "CREATE_BY", "CREATE_TIME", "UPDATE_BY", "UPDATE_TIME", "SYS_ORG_CODE", "NAME", "SEX", "AGE", "REMARK", "BIRTHDAY", "XIA_TIME", "SALARY", "LOG_TXT", "POP_CC", "USER_ID", "DEP_ID", "KAI_GUAN", "FILE2", "PIC", "SHENGSHIQU", "ACCC", "DAA_TYPE", "CCC", "AAA") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25)
|