Re: SQLLDR and LONG: Maintaing <CR>'s in my data.

From: Noodles <noodles_at_aol.com>
Date: 14 Feb 2000 00:55:30 GMT
Message-ID: <20000213195530.27101.00003686@ng-fm1.aol.com>

I did this about 2 years ago but had to pre-format the ascii data file and use the sqlldr "continueif" keyword. Basically I made the long column the last column in the data file, used "%" as the continueif char. Then I put a hex char for termination of the multiline long field.

The formatting program was an extra hoop I had to jump through because there was no way I could load the raw data as is. Once I got it working it was even pretty fast.

However; today there might be easier ways using some of the DBMS utility packages and some PL/SQL.

Cliff >Greetings, this may be a basic question, but here goes.
>
>I need to load data into a LONG column, and I need to
>maintain the CR's in the data.
Received on Sun Feb 13 2000 - 18:55:30 CST