批量插入Oracle数据库:哪个更好:FOR游标循环或简单的Select? [英] Bulk Insert into Oracle database: Which is better: FOR Cursor loop or a simple Select?

问题描述

对于将其批量插入Oracle数据库，哪种方法更好? 像

Which would be a better option for bulk insert into an Oracle database ? A FOR Cursor loop like

DECLARE
   CURSOR C1 IS SELECT * FROM FOO;
BEGIN
   FOR C1_REC IN C1 LOOP
   INSERT INTO BAR(A,
                B,
                C)
          VALUES(C1.A,
                 C1.B,
                 C1.C);
   END LOOP;
END

或简单的选择，例如:

INSERT INTO BAR(A,
                B,
                C)
        (SELECT A,
                B,
                C
        FROM FOO);

任何特定原因之一会更好吗?

Any specific reason either one would be better ?

推荐答案

我建议使用Select选项，因为游标花费的时间更长.
此外，对于必须修改您的查询的人来说，使用Select更容易理解

I would recommend the Select option because cursors take longer.
Also using the Select is much easier to understand for anyone who has to modify your query

这篇关于批量插入Oracle数据库:哪个更好:FOR游标循环或简单的Select?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！