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
"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 Thu Jan 30 2003 - 19:08:27 CST