Thanks. I did it.

--- Varughese M <varughesem@...> wrote:
> Or,
>
> select replace(column,chr(13),null) from table
> ...
>
>
>
>
> --- Godfrey Mwamsojo <goddie_sojo@...> wrote:
> >
> 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 pl/sql loop and
> reconstruct
> > the entire column. I may be able to come up with
> an
> > example later
> >
> > select 'inter'||chr(13)||'national' "Old
> Phrases",
> > substr('inter'||chr(13)||'national', 1,
> > (instr('inter'||chr(13)||'national', chr(13), -1)
> -
> > 1)) ||
> > substr('inter'||chr(13)||'national',
> > instr('inter'||chr(13)||'national', chr(13)) +1)
> > "New Phrase"
> > from dual;
> >
> >
> > Goddie.
> >
> >
> > yoxst <yoxst@...> wrote:
> > 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
> >
> >
> >
> > Ask Your Question by sending Email direct to
> > OraTechSupportGroup@... your
> > comment your suggestion about OraTechSupportGroup
> at
> > Wadhwa_S@...
> > Sameer Wadhwa (Moderator)
> >
> >
> > omment your suggestion about OraTechSupportGroup
> at
> > Wadhwa_S@...
> > Sameer Wadhwa (Moderator)
> >
> >
> >
> >
> >
> >
> > ---------------------------------
> > Yahoo! Groups Links
> >
> > To visit your group on the web, go to:
> > http://groups.yahoo.com/group/OraTechSupportGroup/
> >
> > To unsubscribe from this group, send an email
> to:
> > OraTechSupportGroup-unsubscribe@yahoogroups.com
> >
> > Your use of Yahoo! Groups is subject to the
> > Yahoo! Terms of Service.
> >
> >
> >
> > ---------------------------------
> > Do you Yahoo!?
> > Yahoo! Finance Tax Center - File online. File on
> time.
>
> Find local movie times and trailers on Yahoo!
> Movies.
> http://au.movies.yahoo.com
>


__________________________________
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html