Access/Oracle怎么一次性插入多条数据

Question

比如有这个

insert into HF_IMG_THEME(_id, parentId, imgName) values(0,0,'1.jpg');

insert into HF_IMG_THEME(_id, parentId, imgName) values(1,1,'2.jpg');

有什么语句可以一次插完吗？

Answer 1

insert into HF_IMG_THEME(_id, parentId, imgName) select 1,1,'2.jpg' Union ALL select 1,1,'2.jpg'