Re: changing charakters in long-datatypes

This answer is *ugly* ... better make that *UGLY* ... but ... (oh, yes, it is also totally untested - advance at you own risk) if you have a binary editor available to you (and know how to use it), and the table isn't to unmanagable, you ought to be able to (1) export the table; (2) use a binary editor to change chr(13) to chr(10) [or whatever]; (3) truncate the table; (4) import the table. I don't believe the export (or import) utilities do any checksums.

jc

In article <39F4321D.F9F1901D_at_alcatel.at>,   kacetl harald <harald.kacetl_at_alcatel.at> wrote:
> hi,
>
> i want to change some charakters in a entity (e.g. replace all chr(13)
> with chr(10)) which is of type long. but for that type, functions like
> REPLACE, SUBSTR, ... don't work.
> can someone help me on this issues.
> notice, that this has to be done directly in oracle with without using
> selfwritten functions or even a script (pl/sql, c, perl, ...)
>
> regards, harald
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Nov 12 2000 - 08:19:37 CET