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

Home -> Community -> Usenet -> c.d.o.misc -> Re: [Q] Reading clobs via sqlplus and trimming

Re: [Q] Reading clobs via sqlplus and trimming

From: Stefan Leppert <Stefan.Leppert_at_gmx.net>
Date: 10 Dec 2002 00:01:13 -0800
Message-ID: <8c2093d0.0212100001.3103cfb4@posting.google.com>


Christopher.Jones_at_oracle.comX wrote in message news:>
> Nothing non-hacky springs to mind. (Hacky solution is to pre-process,
> replacing spaces with a token, and post processing to reconvert the
> token.)
>
> Out of interest, why are the trailing spaces important to you?

The clob contains data obtained from a *fixed-format* interface, which can also contain newlines. If any whitespaces are lost, the format cannot be processed anymore.

Thanks for answering,

  Stefan Received on Tue Dec 10 2002 - 02:01:13 CST

Original text of this message

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