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 -> Re: ASCII export of table contents

Re: ASCII export of table contents

From: Jim Smith <jim_at_jimsmith.demon.co.uk>
Date: 1997/01/21
Message-ID: <Q5qQqCAT3P5yEwoX@jimsmith.demon.co.uk>#1/1

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 Smith
Received on Tue Jan 21 1997 - 00:00:00 CST

Original text of this message

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