Thanks for this, I tried the parentheses but I don't think that's the problem.
The reason I'm not using UPDATE is I couldn't figure out how to update from a joined table. There is the option of sub-SELECTs but they rely on only using a single source value (http://en.wikipedia.org/wiki/ UPDATE). Some Oracle 9i forum posts I have found suggest that 9i might require the 'WHEN NOT MATCHED THEN INSERT' clause, but I'm not interested in inserting unmatched values and couldn't figure a way of including it without updating my destination table. Again, thanks, and apologies for my ignorance! Mark On Nov 20, 12:39 pm, Gints Plivna <[EMAIL PROTECTED]> wrote: > one obvious error - merge condition (on clause) must be in parenthesis > i.e > ON (address.add_id = tmpadd.add_id) > > cannot find any immediate problems any more > > Although why do you need merge for this case? It seems just a simple > update would be enough... > > Gints Plivnahttp://www.gplivna.eu --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
