SQL*Load: concatenate lines

From: Michael Barklund <mrb_at_belle.dk>
Date: 1996/06/05
Message-ID: <4p3k7u$pl2_at_thorsen.belle.dk>#1/1


I have a ascii-file containing several records looking like this:

23,12/12/96,"text text text text
text text text text
text text text text
"

My problem is to load the last element (which contains new lines) into a LONG. I have looked at CONTINUEIF, but I simply can't find a way to concatenate the lines.

I would really like to know if it is possible, and if so, how it can be accomplished. Thank you very much for any help.

Michael

PS: just thinking about it, if possible, I guess the new lines will

    be lost ? Received on Wed Jun 05 1996 - 00:00:00 CEST

Original text of this message