SQL Loader/Multiple Inserts

From: DSinger <donny_singer_at_hotmail.com>
Date: 23 Jul 2003 12:44:06 -0700
Message-ID: <ee86bee4.0307231144.549ae043_at_posting.google.com>

I have data formatted the following way in a delimeted file (this is a watered down version to simplify my question):

FirstName|LastName|Phone1,Phone2,Phone3...PhoneN

where there can be multiple Phone Numbers separated by a comma (while the rest of the data is separated by a '|').

The new data structure separates out phone number so there can be as many numbers for each person.

Person

---

PersonID
FirstName
LastName
...

Phone

---

PersonID
PhoneNumber

What I would like to do is use SQL Loader to pull in the data, and then when it hits the list of Phone numbers, to call a function that will loop over the string and put the phone numbers into normalized records, however, I do not know if SQL Loader can handle it. I can always do some sort of temp table to get the data loaded, and then script the rest, but I'd like to know if SQL Loader can do it. Received on Wed Jul 23 2003 - 21:44:06 CEST