select comp_id, status from dba_registry order by 1;

drop table t;
create table t (val varchar2(100));
insert into t values ('<?xml version="1.0" encoding="UTF-8"?>
<test>
  <value>Michel</value>
</test>');
commit;
select extractvalue(xmltype(val),'//value') value from t;

SQL> create table t (val varchar2(100));

Table created.

SQL> insert into t values ('<?xml version="1.0" encoding="UTF-8"?>
  2  <test>
  3    <value>Michel</value>
  4  </test>');

1 row created.

SQL> commit;

Commit complete.

SQL> select extractvalue(xmltype(val),'//value') value from t;
VALUE
-----------------------------------------------------------------------
Michel

1 row selected.