Re: Using TRANSLATE() to detect numeric strings
Date: Fri, 25 Jan 2008 12:06:31 -0800
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.
On Jan 25, 2008 8:41 AM, Niall Litchfield <niall.litchfield_at_gmail.com> wrote:
> Interesting indeed. I've always used the is_numeric function (and possibly
> indexed the column on it.)
> What's that I hear you say? You mean you don't have an is_numeric function
> Mine reads
> create or replace function is_numeric(p_stringval in varchar2) return
> l_numval number;
> l_numval := to_number(p_stringval);
> return 1;
> when others then
> return 0;
> end is_numeric;
> I've never done the runstats thing though.
> On Jan 25, 2008 4:11 PM, Jared Still <jkstill_at_gmail.com> wrote:
> > This week I found it necessary to differentiate between strings that
> > were composed of numeric data and those that were alphanumeric.
> > This was kind of fun an interesting.
> > It was also too long to post here, so I put it on my blog.
> > http://jkstill.blogspot.com/ if you're interested.
> > --
> > Jared Still
> > Certifiable Oracle DBA and Part Time Perl Evangelist
> Niall Litchfield
> Oracle DBA
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 25 2008 - 14:06:31 CST