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>
from each_table
/
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