Re: ASCII output

From: Gary Smith <smithg2_at_iia.org>
Date: 29 Aug 1994 23:13:31 GMT
Message-ID: <33tq2r$99t_at_ankh.iia.org>

An alternative we use is to turn heading off and then:

	select	col1||'~(your choice of delimiter)||,
		col2||'~'||,
		col3||'~'||
	from	table xyz
	where	...;

It's easy to use, and it works!

GTS

---

Jeff Stander (jstander_at_ml.csiro.au) wrote:
: In article 000DBC70_at_life.lu, stefan.kleeschulte_at_life.lu (Stefan Kleeschulte) writes:
: >Hi everybody,
: >...
: >How can I produce a comma delimited (or any other special character) output
: >ASCII file from my Oracle table?

: The perl script 'unloadr' will produce, among other things, a comma-delimited
: ASCII file from Oracle tables.
 

: It is available via anonymous ftp from
 

: host: ftp.ml.csiro.au
: IP: 192.67.12.100
: dir: /software/jstander/oracle_utilties
: file: unloadr unloadr.Z unloadr.zip
 

: A manpage is embedded in the file.
 

: If you need it emailed to you let me know.
 

: ___________________________________________________________________________
 

: Jeff.Stander_at_ml.csiro.au _--_|\ Database Analyst
: CSIRO Division Of Fisheries / \ Pelagic Fisheries Resources
: GPO Box 1538, Hobart \_.--._/ Tasmania 7001, Australia
: Aus Tel: 002-325-332 v Intl Tel: +61-02-325-332
: Aus Fax: 002-325-000 Intl Fax: +61-02-325-000
: ___________________________________________________________________________

--
=================================================================
Gary T. Smith                | My opinions are strictly my own.
smithg2_at_iia.org              |
=================================================================

Received on Tue Aug 30 1994 - 01:13:31 CEST