Re: export to ascii file
From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: 1997/04/02
Message-ID: <334330D4.513C_at_exesolutions.com>#1/1
Date: 1997/04/02
Message-ID: <334330D4.513C_at_exesolutions.com>#1/1
> I would like to know how or where I might find information on how
> to export a table to an ascii file in ORACLE (for example, in SYBASE
> I would use the following:
>
> bcp databaseName..tableName out dataFile -c .....
A simple way, from SQL*Plus would be as follows:
spool c:\temp\textfile.txt
select * from mytable;
spool off
This will create an ASCII text file.
Daniel A. Morgan Received on Wed Apr 02 1997 - 00:00:00 CEST