Re: COPY command in PL/SQL

steven.fabijanski_at_allfirst.com (Steven Fabijanski) wrote in message news:<e627a433.0110311416.7a26b32c_at_posting.google.com>...
> stevenmgarcia_at_hotmail.com (Steve) wrote in message news:<4c049a8c.0110301534.8136646_at_posting.google.com>...
>
> > Any recommendations on how to copy data from several tables from one
> > database to another? This is what I need to do, and I would like to
> > use the copy command because it is more efficient than "insert into
> > table select from"
> >
> > Is there anyway to loop through the copy command?
>
> I haven't tried any tests with it yet, but you might be able to
> combine the 'insert into' with bulk binds. This might be more
> efficient.
>
>
> -Steve F.

What do you mean by that? I guess I'm not familiary with bulk binds. Received on Thu Nov 01 2001 - 20:09:56 CET