Re: reading carriage returns

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 19 Oct 2005 02:20:07 -0700
Message-ID: <1129713607.591865.291460@f14g2000cwb.googlegroups.com>

mike wrote:
> this is probably an off topic question so it should be withdrawn.
>
> i guess after i return the data i should use some kind of app logic to
> reformat it and not in the select statement.

ASCII code for Carriage Return (CR) is 13 and for Line Feed (LF) is 10. In Oracle you can search for these characters in a string by using INSTR and searching for (LF) chr(10) or (CR) chr(13) or (CRLF) chr(13) || chr(10).

Oracle's online doco at http://tahiti.oracle.com can provide you with detailed information on this.

Regards
/Rauf Received on Wed Oct 19 2005 - 04:20:07 CDT