Archive for March, 2007

h1

[Oracle] – Check for any NON-NUMERIC value in a column

March 30, 2007

select *
from table_name
where
instr(translate(column_name,
‘0123456789’,
‘XXXXXXXXXX’),’X’) != length(column_name);

Only record with NON-NUMERIC value in column_name will be displayed.

Advertisements