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

From: <tedchyn_at_yahoo.com>
Date: Tue, 07 Sep 1999 17:07:36 GMT
Message-ID: <7r3god$q1t$1@nnrp1.deja.com>

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. Received on Tue Sep 07 1999 - 12:07:36 CDT