Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: [Q] Reading clobs via sqlplus and trimming
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