Search the web
Sign In
New User? Sign Up
OraTechSupportGroup · Oracle Techniques Discussion Group
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Real people. Real stories. See how Yahoo! Groups impacts members worldwide.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
remove carriage return   Message List  
Reply | Forward Message #414 of 457 |
I have a column containing large data with carriage return. When I
query this column, it will give me several rows for one record because
of carriage return. Does anyone know how to remove the carriage return
in the record?

Thanks




Thu Mar 25, 2004 5:35 pm

yoxst
Offline Offline
Send Email Send Email

Forward
Message #414 of 457 |
Expand Messages Author Sort by Date

I have a column containing large data with carriage return. When I query this column, it will give me several rows for one record because of carriage return....
yoxst
Offline Send Email
Mar 25, 2004
5:35 pm

Try expanding on this, set serveroutput on declare phrase varchar2(32767) := 'inter'||chr(13)||'national'||chr(13)||'lization'; newphrase varchar2(32767) :=...
Godfrey Mwamsojo
goddie_sojo
Online Now Send Email
Mar 27, 2004
2:26 am

Thanks, Goddie. I used replace function in my query, but your pl/sql code gave me hint about chr(13). wei ... time. __________________________________ Do you...
Wei Xia
yoxst
Offline Send Email
Mar 29, 2004
3:21 pm

This query remove a carriage return between two strings, "inter[carriage return]national" and give a single string "international". You may expand this to a...
Godfrey Mwamsojo
goddie_sojo
Online Now Send Email
Mar 27, 2004
2:27 am

Or, select replace(column,chr(13),null) from table ... ... This query remove a carriage return between two ... time. Find local movie times and trailers on...
Varughese M
varughesem@...
Send Email
Mar 27, 2004
2:03 pm

Thanks. I did it. ... __________________________________ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. ...
Wei Xia
yoxst
Offline Send Email
Mar 28, 2004
2:56 am
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help