Re: Select only updated rows from a table

On Mar 3, 4:25 pm, Robert Scheer <rbsch..._at_my-deja.com> wrote:
> Hi.
>
> The materialized views in Oracle have a log mechanism (the FAST
> clause) that can retrieve only the changed rows from a table. Is it
> possible to read this data in any way? I need to write a code that
> from time to time retrieves only the inserted/deleted/updated rows
> from a table and insert these rows on another table. I know that
> timestamp columns can be used for this, but is there any better
> solution to this?
>
> Regards,
> Robert Scheer

how about an after update trigger on the source table? you cannot query mv logs. Received on Mon Mar 03 2008 - 17:09:06 CST