Thread: BULK COLLECT

BULK COLLECT

From
"Paul Dam"
Date:
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Hoi,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Is there an equivalent in PL/pgSQL for BULK COLLECT in PL/SQL of Oracle?</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="NL"
style="font-size:10.0pt;
font-family:Arial">Met vriendelijke groet,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
lang="NL"style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="NL"
style="font-size:10.0pt;
font-family:Arial">Paul Dam</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="NL"
style="font-size:10.0pt;
font-family:Arial">Informatieanalist</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="NL"
style="font-size:10.0pt;
font-family:Arial"> </span></font><font face="Arial"><span lang="NL" style="font-family:Arial"></span></font><p
class="MsoNormal"><fontface="Arial" size="3"><span lang="NL" style="font-size:12.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span lang="NL"
style="font-size:12.0pt"> <imgheight="52" id="_x0000_i1025" src="cid:image001.gif@01C94BE4.5AC2EAC0" width="150"
/></span></font><pclass="MsoNormal"><font face="Times New Roman" size="3"><span lang="NL" style="font-size:12.0pt"><br
/><strong><b><fontface="Times New Roman">Amyyon</font></b></strong><b><span style="font-weight:bold"><br
/></span></b>Bijsterhuizen11.58</span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span lang="NL"
style="font-size:12.0pt">6546AS Nijmegen</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="NL"
style="font-size:10.0pt;
font-family:Arial">050 - 311 5686</span></font><span lang="NL"></span><p class="MsoNormal"><font face="Arial"
size="2"><spanlang="NL" style="font-size:10.0pt; 
font-family:Arial"><a href="http://www.amyyon.nl/" title="http://www.amyyon.nl">www.amyyon.nl</a></span></font><span
lang="NL"></span><pclass="MsoNormal"><font face="Times New Roman" size="3"><span lang="NL"
style="font-size:12.0pt"> </span></font></div>

Re: BULK COLLECT

From
"Scott Marlowe"
Date:
2008/11/21 Paul Dam <p.dam@amyyon.nl>:
> Hoi,
>
>
>
> Is there an equivalent in PL/pgSQL for BULK COLLECT in PL/SQL of Oracle?

I'm not that familiar with BULK COLLECT in oracle.  What does it do?


Re: BULK COLLECT

From
"Paul Dam"
Date:
Scott and others,

The following article by Steven Feuerstein from 2004 explains it quite
clear, I think.

http://www.oracle.com/technology/oramag/oracle/04-jan/o14tech_plsql.html

Paul Dam

-----Oorspronkelijk bericht-----
Van: Scott Marlowe [mailto:scott.marlowe@gmail.com]
Verzonden: vrijdag 21 november 2008 17:46
Aan: Paul Dam
CC: pgsql-sql@postgresql.org
Onderwerp: Re: [SQL] BULK COLLECT

2008/11/21 Paul Dam <p.dam@amyyon.nl>:
> Hoi,
>
>
>
> Is there an equivalent in PL/pgSQL for BULK COLLECT in PL/SQL of
Oracle?

I'm not that familiar with BULK COLLECT in oracle.  What does it do?