Re: Save 1 data

If I want an output file from Oracle which I can read in Excel I generate records with delimiters between the fields that are the same as the delimiters for a csv file.

Jaap.

On Fri, 15 Feb 2002 17:57:15 GMT, damorgan <dan.morgan_at_ci.seattle.wa.us> wrote:

>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 Sat Feb 16 2002 - 04:48:40 CST