| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: ASCII export of table contents
From original note >>
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 ?
<<
Try select * from table_name.
You can use the sql*plus column command to format the output along with
the commands: set linesize xxx
set pagesize 0
You can then use sqlldr to restore the data. This works as long as you do
not have long columns. It will work with long datatype columns if the
actual data values are small enough to fit on a line.
Received on Mon Jan 20 1997 - 00:00:00 CST
 |
 |