sqlldr: import from two lines

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.

Any ideas?

Thanks for your help,
Jan Received on Fri Jun 29 2001 - 07:47:11 CDT