This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / 问一个弱智问题在oracle里面如何一次用insert into插入多条纪录？
谢
-xiagangle(xiagangle);
2002-8-12
{51}
(#688600@0)
-
没人回答？
-xiagangle(xiagangle);
2002-8-13
(#689353@0)
-
回答你的都是弱智,谁敢回答?你若说请教各位大虾/高手,马上就会有答案.
-redice(红冰);
2002-8-13
(#689502@0)
-
:-DD
-babyface(★RAW RAW★);
2002-8-13
(#689510@0)
-
1) If you insert rows from another table:
insert into .....
select .........from
2) if you insert original rows, you may have to do it one by one.
-mage(馅饼);
2002-8-13
(#689517@0)
-
another way is using control file & SQL Loader excutable file.
-lilyba(Sunshine);
2002-8-13
(#689524@0)
-
It depends on your data source. For formated data, you can compose mulitiple INSERT statements with EXCEL.
-cyt(千山万水走遍);
2002-8-13
(#689618@0)