Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Extracting ASCII files from database

Extracting ASCII files from database

From: Sigrid Staudte <sstaudte_at_sachsenlb.de>
Date: Mon, 13 Jul 1998 00:33:32 +0200
Message-ID: <35A939BC.7FA48F00@sachsenlb.de>


Hi,

I have to extract an ASCII file with fixed length of fields from a database table. This file should be transfered to another server and loaded by the sql*loader. Now I´m searching for the best way to extract the ASCII file.
Can I use the spool command and sql*plus or is it necessary to write a pl/sql-programm ?
Who can give an advice?
Who knows a tool what can help to solve the problem ?

Regards,

Sigrid Received on Sun Jul 12 1998 - 17:33:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US