sqlldr: get data from two lines

From: Jan Haase <jh_at_informationsdesign.de>
Date: Fri, 29 Jun 2001 12:55:21 +0200
Message-ID: <3B3C5E99.BBAE634F_at_informationsdesign.de>


Hi.

I want to use sqlldr to insert data (from a file in the following format) into a database:

    06/29/01
    name1 street1 city1
    name2 street2 city2
    name3 street3 city3
    ...

A database row looks like:

    name street city date

So I have to take the value "06/29/01" from the first line and use it with every following line to insert it with the other data.

Probably that's an easy task but I don't find any hints in the documentation.

Thanks for your help,
Jan Received on Fri Jun 29 2001 - 12:55:21 CEST

Original text of this message