PL / SQL

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