Home » SQL & PL/SQL » SQL & PL/SQL » Finding non-numeric values (oracle 9i)
Finding non-numeric values [message #360265] Thu, 20 November 2008 04:13 Go to next message
gauravpuri2002
Messages: 24
Registered: October 2007
Location: Bangalore
Junior Member
Hi
I have table a( id varchar2(10),
name varchar2(30));

I need to find out which are non-numeric id values in the table a.


Regards
Gaurav
Re: Finding non-numeric values [message #360266 is a reply to message #360265] Thu, 20 November 2008 04:16 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
And what have you tried so far?
Re: Finding non-numeric values [message #360267 is a reply to message #360265] Thu, 20 November 2008 04:20 Go to previous messageGo to next message
gauravpuri2002
Messages: 24
Registered: October 2007
Location: Bangalore
Junior Member
I have written as follows

select * from a
where a not like ''%1%2%3%4%5%6%7%8%0%'
Re: Finding non-numeric values [message #360269 is a reply to message #360265] Thu, 20 November 2008 04:27 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read http://www.orafaq.com/forum/t/127675/102589/ and adapt it to (non-)numeric.

Regards
Michel
Previous Topic: SQL to find out OF responsibilities
Next Topic: How Chek numeric value true / false in sql
Goto Forum:
  


Current Time: Sat Dec 03 11:57:12 CST 2016

Total time taken to generate the page: 0.10751 seconds