Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: conditional cursor that will start fetching data from where it stopped in last execution

Re: conditional cursor that will start fetching data from where it stopped in last execution

From: <chris.hulan_at_gmail.com>
Date: 24 Nov 2006 10:48:51 -0800
Message-ID: <1164394131.302645.50660@j44g2000cwa.googlegroups.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US