Re: Q: use invalid_number to check alpha charater in varchar field ?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 08 Sep 1999 18:28:33 +0800
Message-ID: <37D63A51.6E1C@yahoo.com>

tedchyn_at_yahoo.com wrote:
>
> Sir: I have a table test with column c1 with varchar2(10).
>
> c1
> -------
> 1234
> a333
> 3345
> 444b
>
> How do I use pl/sql block and invalid_number exception to output two
> record contain alpha character ?
>
> a333
> 444b
>
> Thanks in advance(tedchyn_at_yahoo.com)
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

select *
from table
where translate(col,'0123456789','9999999999') != 9

or thereabouts
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Sep 08 1999 - 05:28:33 CDT