Hi everyone, I have a task to sync two tables in Oracle. There are two sets of tables. One is the set used by the application. The other set of tables are identical but each has an action field that is used do show if the row should be an add, update, or delete. An interface tool is populating these. I must take these interface tables and update the originals. I hope that makes sense.
Anyway, in FoxPro, I could just loop through each row, run "scatter memvar", locate/seek for the matching row in the original table, and run "gather memvar". Does anyone know of an approach in Oracle like that or perhaps have some advice on doing this? _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
