Re: Export to Fixed width/Delimited File

John Moriarty <jmm_at_wiis.wang.com> wrote:

> Is anyone aware of a utility(Oracle or otherwise) which will allow
>you to create a Tab delimited or fixed width text file from the
>data in an Oracle database table?

Just do it with SQL*Plus:

set heading off
set pagesize 0
set pause off
set linesize (whatever you need)
set feedback off
spool export.asc

select col1, col2, col3
from tab1;

spool off

It is the simpelest way.

+------------------------------------------------------------+
|   Mike Philippens - Gorinchem - The Netherlands, Europe    |
|                 Vijfhart Automatisering bv                 |
|       Oracle Specialists Training and Consultancy          |
|                 Utrecht    The Netherlands                 |
+------------------------------------------------------------+