Re: Flat File

From: Mark Brayshaw <markb_at_global.net.au>
Date: Thu, 02 Dec 1999 01:05:15 GMT
Message-ID: <944096712.150071@localhost.localdomain>

Try the utl_file utility. You can use it to format and write a file to the OS directories.

Regards
--
Mark Brayshaw
Consultant,
Interim Technology
Level 4, 11 Harvest Terrace, West Perth WA 6005, AUSTRALIA Perth: Ph: +61 8 9481 0488 Fax: +61 8 9481 6576 Mobile: 0409 405 411
mailto:markbrayshaw_at_interim.com
http://www.interimtechnology.com.au

Transforming the way people work with technology with PERFORMANCE - TEAMWORK - LEARNING - INNOVATION - INTEGRITY

John Duran <d3plan_at_hotmail.com> wrote in message news:824bnu$5un$1_at_nnrp1.deja.com...
> Need to create a fixed length flat file from a table and have it saved
> to a specific server/directory.
>
> I need to know how to create the control file that specifies the start
> point for each field and the length of each field and filler spaces.
> File has to be exactly 320 characters in length.
>
> I looked in the SQL*Loader documentation as well as several other
> references and could not find an example I could work with.
>
> Any suggested places to find examples.
>
> John
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Dec 01 1999 - 19:05:15 CST