Re: Multiple updates w. static SQL vs. single dynamic SQL update

From: max <cccp.forever_at_gmail.com>
Date: 8 Aug 2006 10:16:38 -0700
Message-ID: <1155057398.439527.51010@m73g2000cwd.googlegroups.com>

Sybrand Bakker wrote:
> On 17 Jul 2006 13:52:50 -0700, "max" <cccp.forever_at_gmail.com> wrote:
>
> >Daniel, thanks for your reply. I got this from the the "Complex IN
> >Demo":
>
> Did you really read *all* of the complex in-demo.
> I bet you didn't.
>
> Please stop top-posting.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

Sybrad, did you read *all* of my reply after I've checked the "complex in-demo"? I bet you didn't. If you did you'd see my opinion about the CAST solution: it will suppress the indexes.

How can one tell if the second block of code of the "Complex IN Demo" is indented to work or not? The code is there, the code is wrong, no mentioning it's not supposed to work.

Barking at people thinking they are stupid is the easiest thing to do. However you make yourself look stupid if it turns out you are barking for reasons that are not even there.

Thanks for your pointers anyway. Received on Tue Aug 08 2006 - 12:16:38 CDT