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>
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