Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL*Loader only loads first row into nested table

Re: SQL*Loader only loads first row into nested table

From: Thomas Kellerer <WVIJEVPANEHT_at_spammotel.com>
Date: Tue, 06 Sep 2005 16:13:26 +0200
Message-ID: <3o5mg7F4bshvU1@individual.net>


On 06.09.2005 16:03 Maxim Demenko wrote:
> The following control file should work with your data.
>
> options (skip=1)
> LOAD DATA CHARACTERSET UTF8
> TRUNCATE
> INTO TABLE user_profile
> FIELDS TERMINATED BY '|'
> TRAILING NULLCOLS
> (
> userid,
> lastname,
> firstname,
> usergroups NESTED TABLE terminated by '|'
> (group_name CHAR terminated by ';')
> ,
> flag char(1) TERMINATED BY WHITESPACE
> )
>
>
> Best regards
>
> Maxim

Brilliant. Works like a charm.

Thanks a bunch
Thomas Received on Tue Sep 06 2005 - 09:13:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US