Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ASCII export of table contents
In article <32E0DDCA.41DF_at_internet.sk>, Karol Michaliak
<delta_at_internet.sk> writes
>Does anybody know how to export table contents in readable ASCII
>format (with delimiters or in fixed width format). Import is
>possible with sqlload but what about export ?
Use SQLPLUS.
Basically it is
spool filename.sql
select *
from table;
spool off
This will give you fixed width output.
There are a number of formatting options to remove headers etc and there
is also SET COLSEP which is available in later versions to allow you to
specify a delimiter.
-- Jim SmithReceived on Tue Jan 21 1997 - 00:00:00 CST