>
> tony sometext 120121122
> mark sometext2 120
> ethan sometext3 124125126
>
>
> the format is:
> name POSITION (1:8) char,
> textstring POSITION (9:19) char,
> code POSITION (20:22) char
>
>
> the problem is, we could have multiple 3character codes in a single
> data record. i want to load each code as a separate database record
> with the same name and text fields.
>
> However, i cant figure out how to get sql*loader to iteratively
>
> check if another 3character code exists in the current data record
> (insert into table ...)
>
> seems a fairly simple thing to do...
>
> any ideas anyone?
Load the data as it is, and then use PL/SQL procedure to do the trick.
--
_/ _/ _/_/_/ ----- Rafał Jank rjank_at_wp-sa.pl -----
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625
_/ _/ _/ --------==* http://szukaj.wp.pl *==----------
Received on Wed Jan 08 2003 - 09:08:43 CST
