RE: SQL*Loader : How can I load the Line Feed as part of data

From: Mandal, Ashoke <ashoke.k.mandal_at_MEDTRONIC.COM>
Date: Mon, 12 Aug 2002 08:58:21 -0800
Message-ID: <F001.004B20F9.20020812085821@fatcity.com>

Hi Rachel,

I have attached the sample data and controlfile, which we are using to load the data. It is loading the line feed characters('\x0d\x0a') as it is. Oracle should store it as Line Feed while loading through SQL*Loader.

When I select this column it should displays something like this. i.e. a line feed instead of \x0d\x0a. But currently it does not happen that way as SQL*Loader loads '\x0d\x0a' as it is.

I may be missing something. I searched in manual and Metalink but not able fix my problem.

Thanks,
Ashoke

When the test is conducted in the Atrium, this parameter encodes to Manual Therapy 50 Hz Induction Atrial Pacing Minimum Interval and Manual Therapy Atrial 50 Hz Induction Instruction Buffer Byte 7 and 9.\x0d\x0a When the test is conducted in the Ventricle,this parameter encodes to Manual Therapy 50 Hz Induction Ventricular Pacing Minimum Interval and \x0d\x0a Manual Therapy 50 Hz Induction Instruction Buffer Byte 3 and 5. and when we select this column

-----Original Message-----
Sent: Monday, August 12, 2002 10:58 AM
To: Multiple recipients of list ORACLE-L

check the utilities documentation, specifically the Field List section and the "terminated by" clause.. you can override the default terminator of line feed. You can also concatenate multiple lines together

• "Mandal, Ashoke" <ashoke.k.mandal_at_medtronic.com> wrote:
  > Greetings,
  >
  > We have one column in a table and this column need to store data with
  > Line Feed, denoted by \x0d\x0a in the following row. This data comes
  > from Sybase database. If \x0d\x0a cannot be loaded as Line Feed
  > through the SQL*Loader then how can we do it?
  >
  > Any help is appreciated.
  > Thanks,
  > Ashoke
  >
  > Data file contains the following one record :
  >
  > crm1d1p1|50 Hz Interval|Software Group|When the test is conducted in
  > the Atrium, this parameter encodes to Manual Therapy 50 Hz Induction
  > Atrial Pacing Minimum Interval and \x0d\x0a Manual Therapy Atrial 50 Hz
  > Induction Instruction Buffer Byte 7 and 9.\x0d\x0aWhen the test is
  > conducted in the Ventricle, this parameter encodes to Manual Therapy
  > 50 Hz Induction Ventricular Pacing Minimum Intervaland \x0d\x0a
  > Manual Therapy 50 Hz Induction Instruction Buffer Byte 3 and
  > 5.|37344||||||||1192
  >
  >
  > Sample Control File :
  > LOAD DATA
  > INFILE param.dat "str X'0d0a'"
  > BADFILE param.bad
  > append into TABLE param_ashoke
  > TRAILING NULLCOLS
  > (DEVICE CHAR(80) TERMINATED BY "|"
  > ,PARAM CHAR(80) TERMINATED BY "|"
  > ,PARAM_TYPE CHAR(20) TERMINATED BY "|"
  > ,SW_NOTE CHAR(4000) TERMINATED BY "|"
  > ,SW_NOTE_CHECKSUM CHAR(38) TERMINATED BY "|"
  > ,FW_VAR_BASE CHAR(80) TERMINATED BY "|"
  > ,FW_VAR_MEMBER CHAR(80) TERMINATED BY "|"
  > ,BIT_OFFSET CHAR(38) TERMINATED BY "|"
  > ,BIT_SIZE CHAR(38) TERMINATED BY "|"
  > ,FW_ENCODE_DECODE CHAR(20) TERMINATED BY "|"
  > ,BIT_LEVEL_TRANS CHAR(80) TERMINATED BY "|"
  > ,ALIAS CHAR(80) TERMINATED BY "|"
  > ,GLOBAL_ID CHAR(38) TERMINATED BY WHITESPACE)
  > --
  > Please see the official ORACLE-L FAQ: http://www.orafaq.com
  > --
  > Author: Mandal, Ashoke
  > INET: ashoke.k.mandal_at_medtronic.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
  > San Diego, California -- Public Internet access / Mailing
  > Lists
  > --------------------------------------------------------------------
  > To REMOVE yourself from this mailing list, send an E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB ORACLE-L
  > (or the name of mailing list you want to be removed from). You may
  > also send the HELP command for other information (like subscribing).
  

  ---

Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mandal, Ashoke
  INET: ashoke.k.mandal_at_medtronic.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Aug 12 2002 - 11:58:21 CDT