create table table1 as (
select '100' as dnet from dual union all
select '99.99' as dnet from dual union all
select ' 12.5 ' as dnet from dual union all
select ' . ' as dnet from dual union all
select ' .' as dnet from dual union all
select ' . ' as dnet from dual union all
select ' * ' as dnet from dual union all
select '-' as dnet from dual
)
version: 18.3
how to select non numeric records ? and in my table this column has varchar data type, i don't want to change it to number.
Thanks,
Nawaz