Re: Extract Oracle data into data file
From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: 2000/09/20
Message-ID: <39C8C975.B1140EAD_at_edcmail.cr.usgs.gov>#1/1
Date: 2000/09/20
Message-ID: <39C8C975.B1140EAD_at_edcmail.cr.usgs.gov>#1/1
There is no problem. This is easily done using SQL*Plus and spooling the output to your flat file. Alternatively, you can use the UTL_FILE package. There are also 3rd party software components that will help too.
HTH,
Brian
Basile Tohoundjona wrote:
>
> I have to extract data from Oracle database into text file using
> user defined stored procedures.
> Can somebody tell me if there is any problem proceding this way?
> Thank,
> Best regards.
-- ======================================== Brian Peasland Raytheons Systems at USGS EROS Data Center These opinions are my own and do not necessarily reflect the opinions of my company! ========================================Received on Wed Sep 20 2000 - 00:00:00 CEST