RDBPROD: How to locate and manipulate special characters such as CR or LF in a text column
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms