Re: PL/SQL Table Question

From: <mcconje_at_my-deja.com>
Date: Thu, 06 Apr 2000 13:36:09 GMT
Message-ID: <8ci3s8$ngh$1_at_nnrp1.deja.com>


[Quoted] In article <8ci30f$mo2$1_at_nnrp1.deja.com>,   Thomas J. Kyte <tkyte_at_us.oracle.com> wrote:
> In article <8ci231$lft$1_at_nnrp1.deja.com>,
> mcconje_at_my-deja.com wrote:
> > Hi All,
> >
> > I recently heard from a co-worker that Oracle 8i allows a "bulk
> commit"
> > from a PL/SQL table to a standard database table. I have been
lookinf
> > for more information on this but as of yet been unable to unearth
> > anything. Does anyone anyone know if this is possible and how to
> > accomplish it.
> >
> > Thanks
> > Jeff McConnell
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> I think you mean BULK BINDS not commits
>
> this allows you to more easily do array inserts/updates/deletes and
> selects from plsql (without having to use DBMS_SQL)
>
> See
>
http://technet.oracle.com/doc/oracle8i_816/appdev.816/a77069/04_colls.ht
> m#23723
>
> thats the plsql manual for 8i
>
> --
> Thomas Kyte tkyte_at_us.oracle.com
> Oracle Service Industries
> http://osi.oracle.com/~tkyte/index.html
> --
> Opinions are mine and do not necessarily reflect those of Oracle Corp
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

[Quoted] Is a bulk bind an insert/update/delete into a normal database table ?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Apr 06 2000 - 15:36:09 CEST

Original text of this message