Re: SQLLoader - Contenate and continueif
From: DA Morgan <damorgan_at_x.washington.edu>
Date: Fri, 11 Feb 2005 15:43:10 -0800
Message-ID: <1108165220.71991_at_yasure>
Date: Fri, 11 Feb 2005 15:43:10 -0800
Message-ID: <1108165220.71991_at_yasure>
rajesh.garigipati_at_gmail.com wrote:
> Did you read my question fully? I would not have asked this question
> for simple fixed length delimiter. Please read the question and
> UNDERSTAND if there is a catch in the question before blasting off.
>
> I have to concatentate variable number of records of second field into
> one field
Can't be done the way you are trying to do it.
Blow it into a staging table and disburse from there.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Sat Feb 12 2005 - 00:43:10 CET