RE: Different ways to transfer data in a table to a FLAT file

Hi All,
  It is available in 7.3.4 as well.
  I must admit that I have limited PL/SQL experience, but this procedure converts a 'PL/SQL' table (a single column array) to a comma separated list. Can you really use this for your data tables? If so, I would love to see an example code that uses this procedure to convert data table to flat files. Until then I am better off using Jared's dump.sql or some other third party tool (probably an expensive one).

Cheers !

• Kirti Deshpande

> -----Original Message-----
> From: Kimberly Smith [SMTP:kimberly.smith_at_gmd.fujitsu.com]
> Sent: Friday, January 12, 2001 3:24 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Different ways to transfer data in a table to a FLAT
> file
>
> Its available earlier then that. I am not sure
> how early it started but I would be suprized if
> it was not in Oracle 7.3.4.
>
> -----Original Message-----
> [mailto:Scott.Shafer_at_dcpds.cpms.osd.mil]
> Sent: Friday, January 12, 2001 12:00 PM
> To: Multiple recipients of list ORACLE-L
>
>
> It appears to be in 8.1.6 (I checked a live db)...
>
> --Scott
>
>
> > -----Original Message-----
> > From: Cale, Rick T (Richard) [SMTP:RICHARD.T.CALE_at_saic.com]
> > Sent: Friday, January 12, 2001 1:08 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Different ways to transfer data in a table to a FLAT
> > file
> >
> > What version of Oracle is this utility?
> >
> > Rick
> >
> > > -----Original Message-----
> > > From: Charlie Mengler [SMTP:charliem_at_mwh.com]
> > > Sent: Friday, January 12, 2001 1:16 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Re: Different ways to transfer data in a table to a FLAT
> > > file
> > >
> > > Additionally, you could use the Oracle supplied procedure
> > > DBMS_UTILITY.TABLE_TO_COMMA if you need a CSV file.
> > >
> > > sfaroult_at_oriole.com wrote:
Received on Fri Jan 12 2001 - 16:22:34 CST