Dumping tables in variable length format
From: Tony O'Hagan <tohagan_at_opcom.com.au>
Date: 1997/11/27
Message-ID: <01bcfad1$ce8e6a80$10d91bcb_at_indira>#1/1
Date: 1997/11/27
Message-ID: <01bcfad1$ce8e6a80$10d91bcb_at_indira>#1/1
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.
Received on Thu Nov 27 1997 - 00:00:00 CET