Martin T. wrote:
> On Jun 1, 11:01 pm, joel garry <joel-ga..._at_home.com> wrote:
>> On Jun 1, 4:58 am, "Martin T." <bilbothebagginsb..._at_freenet.de> wrote:
>>> On Jun 1, 12:01 am, joel garry <joel-ga..._at_home.com> wrote:
>>>> On May 31, 8:39 am, "Martin T." <bilbothebagginsb..._at_freenet.de>
>>>> wrote:
>>> (...)
>>> We have now tried out the solution with SQLLoader and it seems that
>>> this is indeed the tool for the job. Using SQLLoader we see (nearly)
>>> the same performance as with a simple copy over the network.
>>> So it will be SQLLoader + PL/SQL script that copies the data from the
>>> temporary table to the real target table.
>>
>> What is it that makes you need PL/SQL over plain old SQL?
>>
>> jg
>
> Hm ... I guess it's that we want to UPDATE the actual table with the
> data that we put into the temp table. (And PL/SQL is also plain enough
> for me :-)
>
> cheers,
> Martin
Enough perhaps but far less efficient which, I believe, was the point
of Joel's statement. SQL rather than PL/SQL is a good guideline.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sat Jun 02 2007 - 10:36:11 CDT
