Re: Update statement using a join on a materialized view

Andy (andrewfaseuk_at_hotmail.com) wrote:

: update (
: select table_A_parameter as param_to_update
: from Table_A, Table_B, Materialized_View_C
: where Table_A.unique_key_A = Materialized_View_C.unique_key_A
: and Materialized_View_C.unique_key_B = Table_B.unique_key_B
: and Table_B.table_B_parameter = 'X'
: ) set param_to_update = Y;

I guess you could use a pl/sql block and loop over the select and then update just the one table that is actually being updated. Received on Tue Mar 14 2006 - 14:17:40 CST