changing charakters in long-datatypes
From: kacetl harald <harald.kacetl_at_alcatel.at>
Date: Mon, 23 Oct 2000 14:42:05 +0200
Message-ID: <39F4321D.F9F1901D_at_alcatel.at>
Date: Mon, 23 Oct 2000 14:42:05 +0200
Message-ID: <39F4321D.F9F1901D_at_alcatel.at>
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.
regards, harald
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, ...)