Re: flat file

Read the Sql*loader documentation. There are also examples of control files online in $ORACLE_HOME/rdbms/demo.
Sql*Loader is capable of dealing with multiple tables, different record types.

Hth,

--
Sybrand Bakker, Oracle DBA
John Duran <d3plan_at_hotmail.com> wrote in message news:81m71b$e6c$1_at_nnrp1.deja.com...
> I need to send a fixed length file composed of header information and
> order information to a legacy system. (320 characters)
>
> Where can I find an example on how to do this within ORACLE 8.0.5
> running on a Sun SPARC with Solaris 2.6.
>
> Basically every day a batch file needs to be created with billing
> information or basic customer information - and a series of orders each
> with a unique ORDER_ID and information concerning items purchased,
> shipping information etc.
>
> Each detail file may have up to four different types of files each in a
> 320 fixed length character set. Each file type is designated by a 2
> digit file type. re: type 10 is 'Buyer Info', type 30 is 'Shipping
> Info' type 40 is the 'Line Item Record' - one for each item ordered.
>
> John
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Nov 26 1999 - 12:58:34 CST