insert into imafile(frmid,filepath,pages)values(12323,'39753_in_m.jpg',1);
insert into imafile(frmid,filepath,pages)values(12323,'39754_in_m.jpg',1);
insert into imafile(frmid,filepath,pages)values(12323,'39660_in_m.jpg',1);
insert into imafile(frmid,filepath,pages)values(12323,'41537_in_m.jpg',1);
insert into imafile(frmid,filepath,pages)values(12323,'39754_in_m.jpg',1);
insert into imafile(frmid,filepath,pages)values(12323,'39660_in_m.jpg',1);
insert into imafile(frmid,filepath,pages)values(12323,'41537_in_m.jpg',1);
解决方案 »
- INDEX_COMBINE 后出现INDEX FULL SCAN INDEX (UNIQUE) ,何解?
- sql oracle 表连接动态条件差异问题
- A query view LOB's requires OC18 mode,but OC17 mode is used
- 问下Inthirties,一个存储过程里面如何假如alter table 之类的ddl语句?
- 触发器中调用存储过程的问题,请大家帮忙
- 怎样可以使表中的一个字段和序列建立联系?
- ORA-03113: 通信通道的文件结束
- 请问,在存储过程中怎么不能读取v$session 等系统表,怎么读取呢?!!!
- 请问各大侠,oracle如何入门呢?
- 请教oracle8.0.5在win2k advanced server+P4上安装的问题
- 分组求和SQL
- select语句出现的问题
不符合(可能是java)的规范吧
insert into imafile(frmid,filepath,pages)values(12323,'39660_in_m.jpg',1)
insert into imafile(frmid,filepath,pages)values(12323,'39752_in_m.jpg',1)
insert into imafile(frmid,filepath,pages)values(12323,'39755_in_m.jpg',1)
insert into imafile(frmid,filepath,pages)values(12323,'',1)
insert into imafile(frmid,filepath,pages)values(12323,'',1)
insert into imafile(frmid,filepath,pages)values(12323,'',1)
insert into imafile(frmid,filepath,pages)values(12323,'',1)
insert into imafile(frmid,filepath,pages)values(12323,'',1)
insert into imafile(frmid,filepath,pages)values(12323,'',1)
insert into imafile(frmid,filepath,pages)values(12323,'',1)
insert into imafile(frmid,filepath,pages)values(12323,'',1)
改成
insert into imafile(frmid,filepath,pages)
select 12323,'39753_in_m.jpg',1 from dual union all
select 12323,'39754_in_m.jpg',1 from dual ...
试试
再后面以同样形式加上别的记录
每个select 之间加上union all
那又怎么辦?為什么不能一次提交嗎?
select 12323,'39753_in_m.jpg',1 from dual
union all
select 12323,'39754_in_m.jpg',1 from dual
union all
select 12323,'39660_in_m.jpg',1 from dual
union all
select 12323,'39753_in_m.jpg',1 from dual;
insert into imafile(frmid,filepath,pages)values(12323,'39754_in_m.jpg',1);
insert into imafile(frmid,filepath,pages)values(12323,'39660_in_m.jpg',1);
insert into imafile(frmid,filepath,pages)values(12323,'41537_in_m.jpg',1);
这样写貌视没有问题呀!