ken quirici wrote:
> On Sep 15, 12:26 pm, ErikYkema <erik.yk..._at_gmail.com> wrote:
>> On Sep 14, 9:09 am, codadilupo <codadil..._at_operamail.com> wrote:
>>
>>> Mladen Gogala wrote:
>>>> First, capital letters in the title are considered offensive.
>>>> Second, have you tried both versions and benchmarked it? How do
>>>> you expect somebody to give you a sound advice without providing
>>>> any additional information? I would go with what works faster for
>>>> you. You can try it out, it's not illegal, unless you live in TX.
>>> Sorry for the capital letters. My problem is that I'm not able to figure
>>> out the syntax for using execute immediate and bulk collect with a
>>> variable number of columns, so I cannot benchmark the two solutions.
>>> --
>>> CdL
>> Hi Coda Di Lupo,
>> Both D A Morgan's sample, dbms_sql I assume and your own construction
>> will lead to a solution.
>> I recommend reading a recent book by Steven Feuerstein and Tom Kyte -
>
> I couldn't find anything by these two authors (a page or two of each
> separately)
> in Barnes&Noble or Amazon. You have a title handy?
>
>> this will bring you up to speed and see the value of DA Morgan's
>> sample.
>> Regards,
>> Erik Ykema
>> Regards,
>> Erik
http://www.apress.com/book/search?searchterm=Kyte&act=search&submit.x=0&submit.y=0
http://www.amazon.com/s/ref=nb_ss_gw/002-5332894-2612029?initialSearch=1&url=search-alias%3Daps&field-keywords=Steven+Feuerstein&Go.x=0&Go.y=0&Go=Go
--
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 Sun Sep 16 2007 - 20:59:01 CDT
