[ORACLE] 숫자가 포함된 row 찾고자 할때

with tabs
as
(
select 'aaa1234' col_nm from dual
union all
select 'bbbbbbb' col_nm from dual
union all
select 'ccc6754' col_nm from dual
union all
select 'ddd09574' col_nm from dual
)
select col_nm, translate(col_nm,'0123456789'||col_nm,'0123456789') get_num from tabs