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: 2882
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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
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 Feb 15 13:57:30 CST 2025