Re: Sqlloader function

See the docs regarding the 'When' and 'Position' clauses of SqlLoader control files... ( in the Server Utilities manual) You could check the value of id and then use a different positional notation to select the field to load...

Hope it provided some ideas...

shan168 <shan168_at_my-dejanews.com> wrote:

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

To reply please remove the 'nospam' part of the address Received on Fri Mar 26 1999 - 21:11:12 CET