Re: Data extraction

From: Breno de Avellar Gomes <brenogomes_at_ieee.org>
Date: Wed, 20 Oct 1999 20:06:35 +0100
Message-ID: <380E12BB.266DBC4F@ieee.org>

you can try this:

set pages 0
set echo off
set feedback off
set colsep ':'
spool <filename>
select * from <tablename>;
spool off

set colsep to ascii tab character

Nick wrote:

> Hi,
>
> Im wondering if there is a way to extract data from an Oracle database,
> in tab delimited .dat files. I know this can be done via an odbc
> connection with Access and then 'save as' but we have over a hundred
> tables. Thanks,
>
> -Nick

--
Breno de Avellar Gomes
Database Applications & Internet Developer

Arquivo-Sistemas de Bases de Dados
P. O. Box 5006
4017-001 Porto
Portugal

brenogomes_at_ieee.org
Cellular: +351 931 7383469
ICQ # 35567342 Toll free fax and voice recorder from USA 1-888-EXCITE2 extension 291-303-8152

Outside USA (international fares apply) 1-917-463-3173 Received on Wed Oct 20 1999 - 14:06:35 CDT