Re: Using TRANSLATE() to detect numeric strings

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 25 Jan 2008 12:21:27 -0800
Message-ID: <bf46380801251221q51c994e0l3de4987ac2cff43b@mail.gmail.com>

On Jan 25, 2008 12:06 PM, Jared Still <jkstill_at_gmail.com> wrote:

> LOL!
>
> I have that function, and in fact I believe I wrote pretty much the same
> thing about 10 years ago.
>
> Just forgot about it.
>
> IAC, I didn't try it, though I suspect it will be slower than the others.
>
> I'll try it for comparison.
>
>

Updated. translate is still much faster .

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jan 25 2008 - 14:21:27 CST

This message: [ Message body ]
Next message: Elliott, Patrick: "RE: Help with moving lobsegments and lobindexes...."
Previous message: Bobak, Mark: "RE: Help with moving lobsegments and lobindexes...."
In reply to: Jared Still: "Re: Using TRANSLATE() to detect numeric strings"
Next in thread: Herring Dave - dherri: "RE: Using TRANSLATE() to detect numeric strings"

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

Original text of this message