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
Galen Boyer wrote:
> 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'
>
An after insert trigger is ideal for this
Cheers Received on Fri Nov 24 2006 - 12:48:51 CST