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

Malcolm Dew-Jones wrote:

> How about 3.
>
> insert the values to be selected into a global temporary table and then
>
> update customers
> set active = 1
> where customer_code in
> ( select selected_code from my_selection_table
> )

Check out the demo I referenced ... inserting into a table is unnecessary.

-- 
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