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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
