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: Ban Spam <ban-spam_at_operamail.com>
Date: Fri, 31 Jan 2003 01:08:27 GMT
Message-ID: <Xns9313AEAE52DF3SunnySD@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 Thu Jan 30 2003 - 19:08:27 CST

Original text of this message

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