Re: ascii text unload

From: John Strange <jstrange_at_imtn.dsccc.com>
Date: 28 Oct 1998 18:07:06 GMT
Message-ID: <717mga$frl$1_at_relay1.dsccc.com>


spool ascii

select col_1 || ','
       col_2 || ','
       col_3 || ','
	.
	.
	.

from each_table
/

spool off

ljanda_at_checkstop.com wrote:
: I have an Oracle 5 system and need to get a simple
: delimited ascii text file unload. How is this done?

: I have run exp but it creates a file with sql code.
: Thanks

: -----------== Posted via Deja News, The Discussion Network ==----------
: http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

--
While Alcatel may claim ownership of all my ideas (on or off the job),
Alcatel does not claim any responsibility for them. Warranty expired when u
opened this article and I will not be responsible for its contents or use.
Received on Wed Oct 28 1998 - 19:07:06 CET

Original text of this message