Re: exporting to ASCII

On Tue, 18 May 1999 14:38:22 -0500, Richard Spelling <richard_at_spellingbusiness.com> wrote:

>IS there any way to do a database dump to some kind of delimited ASCII
>file?

Short of writing your own program, the only convenient way that I've found is to use SQL*Plus to spool data to a file. I usually do something like this:

	set pagesize 0
	spool my_file.csv
	
	--Select some CSV data
	select '"' || cust_name || '",' || cust_no
	from cust_table;

	spool off

The above should give you a file that looks like this:

	"Jonathan Gennick",101
	"Dave Leinen",102
	...

regards,

Jonathan Received on Wed May 19 1999 - 10:36:58 CDT