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
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 FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
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