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

Hi all,

  I am new to the list. But can somebody give me URL of or paste the script Jared's dump.sql in the email please. After having so much of discussion of dump.sql I am really eager to see the script itself.

-Hitarth

-----Original Message-----
From: Deshpande, Kirti [mailto:kirti.deshpande_at_verizon.com] Sent: Friday, January 12, 2001 5:22 PM
To: Multiple recipients of list ORACLE-L Subject: 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:
> > > >
> <SNIP>
> --
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may