Using TRANSLATE() to detect numeric strings

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 25 Jan 2008 08:11:38 -0800
Message-ID: <bf46380801250811t630ff2eck97ec3eb3a77c35dd@mail.gmail.com>

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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Jan 25 2008 - 10:11:38 CST

This message: [ Message body ]
Next message: John Thompson: "Re: Gathering of Statistics"
Previous message: Mason, Tara: "SQLLDR using Direct=True with Multiple Physical Records"
Next in thread: Niall Litchfield: "Re: Using TRANSLATE() to detect numeric strings"
Reply: Niall Litchfield: "Re: Using TRANSLATE() to detect numeric strings"
Reply: 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