Home › Programming

PL / SQL

Thu, 03/06/2008 - 23:29 — panticz

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

Do you like this page? Then support it. Please click the AD below and visit the sponsor. Thank you!