<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Oracle PL/SQL &amp;quot;forall&amp;quot; inserts and SAS multi-inserts in SAS Programming</title>
    <link>https://communities.sas.com/t5/SAS-Programming/Oracle-PL-SQL-quot-forall-quot-inserts-and-SAS-multi-inserts/m-p/74275#M16018</link>
    <description>We have found that "forall" out performs bulkload in our situation.   We ended up making Oracle "forall" Procedures to call from SAS.</description>
    <pubDate>Mon, 23 Aug 2010 13:39:33 GMT</pubDate>
    <dc:creator>JMarkW</dc:creator>
    <dc:date>2010-08-23T13:39:33Z</dc:date>
    <item>
      <title>Oracle PL/SQL "forall" inserts and SAS multi-inserts</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Oracle-PL-SQL-quot-forall-quot-inserts-and-SAS-multi-inserts/m-p/74273#M16016</link>
      <description>I'm curious whether SAS Multi-Insert technology actually invokes something similar to PL/SQL "forall" inserts.   The speed is very similar on systems that I'm using.   Both are almost the same speed assql*loader</description>
      <pubDate>Thu, 08 Apr 2010 15:04:47 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Oracle-PL-SQL-quot-forall-quot-inserts-and-SAS-multi-inserts/m-p/74273#M16016</guid>
      <dc:creator>JMarkW</dc:creator>
      <dc:date>2010-04-08T15:04:47Z</dc:date>
    </item>
    <item>
      <title>Re: Oracle PL/SQL "forall" inserts and SAS multi-inserts</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Oracle-PL-SQL-quot-forall-quot-inserts-and-SAS-multi-inserts/m-p/74274#M16017</link>
      <description>This specific question is best answered by a SAS/ACCESS developer.&lt;BR /&gt;
Try to get an answer via tech support, or if you attend Global Forum - grab someone at the demo stations.&lt;BR /&gt;
&lt;BR /&gt;
In my mind, there are some situations when bulkload is faster, especially for really large loads.&lt;BR /&gt;
&lt;BR /&gt;
/Linus</description>
      <pubDate>Tue, 13 Apr 2010 07:50:47 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Oracle-PL-SQL-quot-forall-quot-inserts-and-SAS-multi-inserts/m-p/74274#M16017</guid>
      <dc:creator>LinusH</dc:creator>
      <dc:date>2010-04-13T07:50:47Z</dc:date>
    </item>
    <item>
      <title>Re: Oracle PL/SQL "forall" inserts and SAS multi-inserts</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Oracle-PL-SQL-quot-forall-quot-inserts-and-SAS-multi-inserts/m-p/74275#M16018</link>
      <description>We have found that "forall" out performs bulkload in our situation.   We ended up making Oracle "forall" Procedures to call from SAS.</description>
      <pubDate>Mon, 23 Aug 2010 13:39:33 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Oracle-PL-SQL-quot-forall-quot-inserts-and-SAS-multi-inserts/m-p/74275#M16018</guid>
      <dc:creator>JMarkW</dc:creator>
      <dc:date>2010-08-23T13:39:33Z</dc:date>
    </item>
  </channel>
</rss>

