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