求指导!oracle建表错误!
create table t_todo
(
F_ID int not null,
F_PARID int,
F_ACTION int not null,
F_ACTNAME varchar(16),
F_CLIATTR varchar(1),
F_DTIME varchar(14) not null,
F_DEVID varchar(8) not null,
F_SOFTID varchar(20),
F_FILE varchar(80),
F_ZIPFG varchar(1),
F_PARAM varchar(120),
F_DEFTIME varchar(14),
F_DEFMAN varchar(12),
F_TRYTIME int default 0,
F_TRYMAX int,
F_DONE varchar(1) not null,
F_RCINFO varchar(40),
F_DONETIME varchar(14),
F_NEXTTIME varchar(14) not null,
F_JSCRIPT blob(8192),
F_PAD1 varchar(10)
);
执行后提示 ORA-00907: 缺失右括号,问题似乎出在 F_JSCRIPT blob(8192) ,请问blob类型是否能指定大小?