Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.server -> Re: How to handle varchar(4000) field containing carriage returns in reporting?

Re: How to handle varchar(4000) field containing carriage returns in reporting?

From: Sameer <dolpheen_at_gmail.com>
Date: 17 Oct 2006 23:02:16 -0700
Message-ID: <1161151336.089891.13450@h48g2000cwc.googlegroups.com>

Thanks for the help.
What worked for me is:
REPLACE(fieldname, CHR(13)||chr(10), ' ') I have to replace the combination of CR and LF as I am using Windows OS. Received on Wed Oct 18 2006 - 01:02:16 CDT

This message: [ Message body ]
Next message: sanjeev: "Configure IE 6.0 for iSQL PLUS"
Previous message: wagen123_at_yahoo.com: "Re: Truncate command internal behavior"
In reply to: DA Morgan: "Re: How to handle varchar(4000) field containing carriage returns in reporting?"
Next in thread: Carlos: "Re: How to handle varchar(4000) field containing carriage returns in reporting?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US