Matt how many fields in the row need to be updated? To me your process is get all rows that need to be inserted into other system. Then insert that data into other system without the flag column right? /* 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". */
One statement to do it is below for Oracle INSERT INTO tbl_temp2 (fld_id, field list here....)SELECT tbl_temp1.fld_order_id, field list here ....FROM tbl_temp1 WHERE tbl_temp1.columnYouFindTheChangeHere; HTH On Wed, Sep 14, 2016 at 8:08 AM, Matt Wiedeman <[email protected]> wrote: > I could write a massive update statement but there are a lot of fields. I > may end up doing it that way. > > I just found the %ROWTYPE attribute...it seems to work like a "scatter > memvar" but there is no "gather memvar" equivalent that I can find. > > -----Original Message----- > From: Koen Piller [mailto:[email protected]] > Sent: Wednesday, September 14, 2016 1:24 AM > To: ProFox Email List > Subject: Re: Oracle question > > Hi > Can you use a SQL update ? > Regards > Koen > > Op woensdag 14 september 2016 heeft Stephen Russell <[email protected]> > het volgende geschreven: > > > Try this. > > https://docs.oracle.com/cd/B28359_01/appdev.111/b28843/ > > tdddg_procedures.htm > > > > There is no scatter memver in oracle. > > > > On Tue, Sep 13, 2016 at 6:43 PM, Matt Wiedeman > > <[email protected] <javascript:;>> > > wrote: > > > > > 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? > > > > > > [excessive quoting removed by server] _______________________________________________ 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/cajidmylqeuob9ig90-ge8r6tfh+zm9grrrumk0nz+gp_c9m...@mail.gmail.com ** 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.
