Re: Dumping tables in variable length format

Tony O'Hagan wrote at 27-Nov-97 02:14:57

>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.

Try something like this:

set pagesize 0
...
spool filename
select to_char(field1)||',"'||field2||'",'||to_char(field3)||','||... spool off

Well, it is quite clumsy but is should work!

Hope that helps.

CU,
Lothar

--
Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Schulstr. 12            | lothar.armbruester_at_t-online.de
D-65375 Oestrich-Winkel |