How to write query for getting non numeric values

Hii

i have a emp table .empno stores all the numeric values
and accidentally i have added some values with combination of alphabets and special characters
now i need a query which will return all the records which is having alphabets and characters in their value.
assume tht table has records in lakhs.

Please answer this question

thankx in advance
sreekanth
  • Interview Candidate
  • 7
  • 2884

Showing Answers 1 - 7 of 7 Answers

Amit

  • Mar 23rd, 2007
 

Hello ,
First of all if you can tell me what version  you are using that will be great
Cause Oracle10 has reqular expresion  property.

Mean while i would sugest to write a page where you can get all the Emplids,Iterate them and check if they are numeric or not.If not put it in a array and modify as per your need.


Thanks
Amit

  Was this answer useful?  Yes

damodharyadav

  • May 23rd, 2011
 

select non_num_col from sample_table
where length(non_num_col) -
length(replace(translate(non_num_col,'qwertyuiopasdfghjklzxcvbnm',' '),' ','')) <> 0
 

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions