Re: export to ascii file

From: mjc <cavett_at_globalnet.co.uk>
Date: 1997/03/30
Message-ID: <01bc3d34$170db7e0$a9567ec2@cavett.globalnet.co.uk>#1/1

Hi Raul

In a SQL script file try the following SET commands (v7.2)

SET LINESIZE 999
SET HEAD OFF
SET FEEDBACK OFF
SET PAGESIZE 0
SET TRIMSPOOL ON (v.7.2)
SPOOL output_filename.LIS

/*
select statement goes here
*/
/

SPOOL OFF
EXIT The output_file.LIS will contain ascii of 1 line per row from your select statement. Nb. Assumes a max. linesize of 999 characters.

Help this helps

-- 
	- Martyn
	  Senior ORACLE Analyst
	  Surrey, England.
	  home: cavett_at_globalnet.co.uk
	


Raul Sanchez <rsanchez_at_lingocd.com> wrote in article
<333DC0E2.1FAB_at_lingocd.com>...


> Hi,

> 

> I would like to know how or where I might find information on how

> to export a table to an ascii file in ORACLE (for example, in SYBASE

> I would use the following:

> 

> bcp databaseName..tableName out dataFile -c .....

> 

> In order words, what is the equivalent to this statement above

> in ORACLE.  Thanx for you kind help in advance.

> 

> --Raul

>

Received on Sun Mar 30 1997 - 00:00:00 CST