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
Mar 23rd, 2007
3
2977

Basics

Answer

Showing Answers 1 - 3 of 3 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

neha.awasthi1
Profile Answers by neha.awasthi1 Questions by neha.awasthi1

May 19th, 2011

select order_status from orders where TRANSLATE (order_status, CHR (1) || '1234567890', CHR (1)) is not null

damodharyadav
Profile Answers by damodharyadav

May 23rd, 2011

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