Select only updated rows from a table

From: Robert Scheer <rbscheer_at_my-deja.com>
Date: Mon, 3 Mar 2008 13:25:19 -0800 (PST)
Message-ID: <ddfb5809-d412-4546-9aed-692db35aaed3@e23g2000prf.googlegroups.com>

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 Received on Mon Mar 03 2008 - 15:25:19 CST

This message: [ Message body ]
Next message: Gokul: "Delete behaviour"
Previous message: hpuxrac: "Re: why does 11g plsql_code_type default to interpreted?"
Next in thread: Pete: "Re: Select only updated rows from a table"
Reply: Pete: "Re: Select only updated rows from a table"
Reply: Steve Howard: "Re: Select only updated rows from a table"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message