Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: conditional cursor that will start fetching data from where it stopped in last execution
On 24 Nov 2006, garfield.jack_at_gmail.com wrote:
> Can anybody tell me if a cursor can be defined in such a way that it
> will copy only the newly inserted data into table 'a'
Have the cursor defined to pick up only the newly inserted rows. Maybe NOT IN 'b'. Maybe transaction time > last execution date.
-- Galen BoyerReceived on Fri Nov 24 2006 - 09:10:02 CST