SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Remove/Replace CR/LF Characters in Column

467765Nov 11 2005 — edited Nov 13 2005

I have two character fields in oracle.

The second field include character and some CR/LF characters.

How can I trim out those special characters and then merge the two fields in the first field.

i.e
FIELD 1 =
"MY SAVINGS"

FIELD 2 =
"A1
A2
A3"

RESULT FIELD1 = "MY SAVINGS - [A1, A2, A3]

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 11 2005

Added on Nov 11 2005

4 comments

11,662 views