Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Using SQL*Plus for loading file containg CR/LF as value of colum

Re: Using SQL*Plus for loading file containg CR/LF as value of colum

From: Anton Buijs <aammbuijs_at_xs4all.nl>
Date: Fri, 31 Jan 2003 18:08:15 +0100
Message-ID: <3e3aad88$0$49099$e4fe514c@news.xs4all.nl>


Well, should be the same and it is!
I was a little bit in a hurry and looked it up wrong. So sorry Randi, apply Ban Spam's correction

Ban Spam <ban-spam_at_operamail.com> schreef in berichtnieuws Xns9313AEAE52DF3SunnySD_at_68.6.19.6...
| "Anton Buijs" <aammbuijs_at_xs4all.nl> wrote in
| news:3e378f0d$0$49108$e4fe514c_at_news.xs4all.nl:
|
| > That application should generate:
| > insert into ..... values (..., 'this is the first
| > line'||chr(13)||'second line' ,...)
| > Character 13 is the decimal value of the CR character.
| > Character 15 is the decimal value of the LF character, mayby you need
| > to concatenate it too.
| >
|
| Hmmm...........
| My ASCII chart says that decimal 13 is a CR
| My ASCII chart says that decimal 15 is an SI
| My ASCII chart says that decimal 10 is a LF
| Where American Standard Code for Interformation Interchange => ASCII
| Maybe a different chart is used in Europe.
|
| HTH & YMMV
|
|
| HAND!
Received on Fri Jan 31 2003 - 11:08:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US