小弟是这样写的,可是不成功
insert into imgtbl(code,type,ephoto) select code,type,
dbms_lob.substr(ephoto ,dbms_lob.getlength(ephoto)) as ephoto from img_temptbl where code='1234'
其中imgtbl是正式表,img_temptbl是临时表,ephoto为blob字段
insert into imgtbl(code,type,ephoto) select code,type,
dbms_lob.substr(ephoto ,dbms_lob.getlength(ephoto)) as ephoto from img_temptbl where code='1234'
其中imgtbl是正式表,img_temptbl是临时表,ephoto为blob字段
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货