RDBPROD: How to locate and manipulate special characters such as CR or LF in a text column
(Doc ID 1282872.1)
Last updated on JANUARY 10, 2018
Applies to:Oracle Rdb Server on OpenVMS - Version 7.0 and later
HP OpenVMS Alpha
HP OpenVMS VAX
HP OpenVMS Itanium
Is it possible to locate a special character such as a CR (carriage return) in a string and, if necessary, replace it, either temporarily or permanently?
Such special characters can cause problems in RMU/UNLOAD to an ASCII file and then displaying, or simply displaying them in interactive SQL.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!