Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: sql statement to find carriage return

Re: sql statement to find carriage return

From: Bill Thomason <billthomason_at_charter.net>
Date: Tue, 16 Dec 2003 19:01:24 -0500
Message-ID: <vtv76o279scc64@corp.supernews.com>


what an asshole

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:a5uutvou3ei0ov1t81mrqpedr5v2t264pg_at_4ax.com...
> On Tue, 16 Dec 2003 15:33:14 -0500, "Bill Thomason"
> <billthomason_at_charter.net> wrote:
>
> >I am looking for a simple sql statement to find carriage returns in an
> >orical 9i database.
> >i haven't been able to find anything to help
> >
> >Thanks
> >Bill
> >
>
> Realise carriage return can be represented as chr(13).
> Realise you can use the function instr to search for chr(13)
> Now look in appropiate places in the sql reference and complete your
> homework assignment
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Tue Dec 16 2003 - 18:01:24 CST

Original text of this message

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