Re: Save 1 data

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Fri, 15 Feb 2002 17:57:15 GMT
Message-ID: <3C6D4BFF.9BC5CF48@ci.seattle.wa.us>

Why export into Excel when you have a perfectly good solution inside of Oracle.

The steps:
1. Create another copy of the table without any data 2. Put an on insert, update and delete trigger on the original table that

inserts records into the copy
3. Once a week compare the two tables and truncate the copy

If no records in the copy ... nothing was changed. Whatever records are in the copy are the ones that were changed. A simple flag will tell you which part of the trigger fired.

Daniel Morgan

s Lehaire wrote:

> Hi,
> I want to save a table 1 time weekly because the parameters are changing
> frenquently in it.
> Can I export this table into excel for exemple? (i have to compare it every
> week)
> so if anyone have a script?
> Thx
> (I'm newbie and french)
Received on Fri Feb 15 2002 - 11:57:15 CST