Thanks Diana for letting me know about the replace function. A
little more research and my problem was solved.
Satish IyerDBACCSS Team 684-3016>>>
Diana_Duncan_at_ttpartners.com 05/30/01 07:50PM
>>>Satish,You can do a couple of things...in the query
you could to areplace(column1, chr(10), '~') (or some other unlikely
character orstring), then do a replace again in the SQL*Loader script to get
thecarriage returns back in there. Or you could use the query to put
acharacter in the front of each true record, something likeselect
'#' || col1, col2, col3, ....and then use the SQL*Loader commands for
concatenating records. Can'tremember offhand how that one works,
though...HTH,Diana DuncanTITAN Technology PartnersOne
Copley Parkway, Ste 540Morrisville, NC 27560VM: 919.466.7337 x
316F: 919.466.7427E:
Diana_Duncan_at_ttpartners.com
"Satish
Iyer"
<Satish.Iyer_at_ci.seat
To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
tle.wa.us>
cc:
Sent
by:
Fax
to:
root_at_fatcity.com
Subject: SQL*LOADER
problem
05/30/2001 08:05
PM
Please respond
to
ORACLE-L
Hi everyone.Having this typical problem with sql*loader.
I am extracting data out froma table and this table has a field in which
users have put in a new linefeed character. Now when I extract the
data out using SQL*PLUS itobviously has a
problemeg.1 First line of stt
2333232 Second line2 Full
line
23232323 Again a partial
2323232 line.Now if such a table was
extracted to a txt file, the sqlldr runs into aproblem of getting the
second half of the line as expected. Any ideas howthis could be avoided
?Hope I explained that okay.Satish IyerDBACCSS Team
684-3016-- Please see the official ORACLE-L FAQ: <A
href="
http://www.orafaq.com">
http://www.orafaq.com-- Author:
INET: Diana_Duncan_at_ttpartners.comFat City Network
Services -- (858) 538-5051 FAX: (858) 538-5051San
Diego, California -- Public Internet
access / Mailing
Lists--------------------------------------------------------------------To
REMOVE yourself from this mailing list, send an E-Mail messageto:
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list
you want to be removed from). You mayalso send the HELP command for
other information (like subscribing).
Received on Thu May 31 2001 - 10:56:07 CDT
