Re: Dump Ascii File From Oracle 6

In article <D07tCx.879_at_netnews.whoi.edu> dhiltz_at_whsun1.whoi.edu (David Hiltz) writes:
>Willard Coates (WDCOATES_at_PURCCVM.BITNET) wrote:
>
>: Jeff Gerth wrote:
 

>: >I'm trying to dump oracle table data to an comma delimited ascii file...
>: >I'm sure there has to be a convenient way of doing this, but I have yet
>: >to find it.... This is in the PC based version of oracle 6... any
>: >suggestions?
 

>: > J.G.
>
> If you could get oraperl working on the PC, you could use unloadr which
> does exactly what you trying to do. I use it on a Unix box and it works
> great.
>
> -----------
> David Hiltz
> dhiltz_at_whsun1.wh.whoi.edu
> Network System Administrator
> Northeast Fisheries Science Center
> ######&_at_&######

CHAZ>	94-12-08 Thu
	If you don't have oraperl and can't get it you can still
	get the job done by writing a shell script that executes
	splplus to do a describe on the table and then uses that
	info to generate and then run a sql script that selects
	all the fields in the table seperated by commas.
	I had to do this recently on a system where oraperl
	was not available.

	\             ____       Chaz Sliger
	 \            ___\\        Portland, OR
	__\===\    __/_HD)\\<)       chaz_at_atlas.com
	 /   \ \==/ V V  /  \\ __      "Let the rough side drag,
	| (_at_) |_____###/     \/  \      Let the smooth side show..."
	 \___/  89 FXSTS      \__/        -Jesse Winchester
	==========================================================