Sqlloader function

From: shan168 <shan168_at_my-dejanews.com>
Date: Fri, 26 Mar 1999 19:28:38 GMT
Message-ID: <7dgn4o$9di$1_at_nnrp1.dejanews.com>



Hi,

[Quoted] Does anybody know how to convert one record from a flat file into several records in Oracle? For example, the flat file looks like:

id legal1 legal2 legal3 legal4

And the Oracle table looks like:

id1 legal1 (first record)
id2 legal2 (2nd record)
id3 legal3 (3rd record)
id4 legal4 (4th record)

Any help will be deeply appreciated!

Steph

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Mar 26 1999 - 20:28:38 CET

Original text of this message