Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Using SQL*Plus for loading file containg CR/LF as value of colum
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