Re: Dumping tables in variable length format

Tony O'Hagan wrote:
>
> I need to export Orcale 8 tables in the standard comma delimited format
> such as:
>
> 1,"ABC" ,"Alabama",y,y,y,"DEF", 2,97/12/03
> 1,"DEF","Washington",y,y,y,"GHI", 2,97/12/23
>
> I'm familiar with using spool and select commands in SQL Plus which outputs
> in
> fixed width formats.
>
> Thanks.
> Tony O'Hagan.

select field1 || ',"' ||

	field2 || '","' ||
	field3 ....

	fieldn-1 || ',' ||
	to_char(fieldn,'YY/MM/DD')

Mike Krolewski Received on Mon Dec 01 1997 - 00:00:00 CET