Re: Data Out of Oracle

BEH_at_csd.uwm.edu (Barbara Hiles) wrote:
>We are running Oracle 7.2 with procedural option.
>I am planning on writing triggers to capture this action.
>My question is how to get the data out of Oracle.
>Ideally I would like to do this periodically (i.e. write
>out everything prior to a point in time).
>Can PL/SQL write out a sequential file?

There is a file handling package available for Oracle server, but I think you need to go to 7.3. In the mean-time, you could write the records you want to get out into a temporary table, and then use SQL*Plus or similar to select out the data from the temp table into the flat file format of your choice. Putting a datetime field on the temp table will allow you to do this periodically. Received on Wed Sep 18 1996 - 00:00:00 CEST