View all DBA objects (all tables from HR)

select *
from dba_objects
where OWNER = 'HR'
and OBJECT_TYPE = 'TABLE'

Remove non numeric char

select REGEXP_REPLACE(coll, '[^[:digit:]]', '')
from TABLE