SQLLoader - Contenate and continueif

From: <rajesh.garigipati_at_gmail.com>
Date: 10 Feb 2005 18:09:52 -0800
Message-ID: <1108087792.926748.35330_at_l41g2000cwc.googlegroups.com>



I have to load the following data into a table with same structure

Cd Text

AA AAAAAAAAAAAAAAAAAAAAAAAAAAA
BB BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB
CC CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC

   CCCCCCCCCCCC

DD DDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDD
EE EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE
FF FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
   FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
   FFFFFFFFFFFF
GG GGGGGGGGGGGGGGGGGGGGGGGGGGG


The table has 2 columns - cd, text.

The length of text in the table is varchar2(1000).

The file has only 40 characters of text for each line. If the length exceeds 40 characters, it is moved to the next line as for the CC and FF.

The texts across mutliple lines should be concatenated into one record

Is there an option to do this through sqlldr? Received on Fri Feb 11 2005 - 03:09:52 CET

Original text of this message