drop table ttest;
CREATE TABLE ttest (id number,vv varchar2 (300))

drop table xbooks;
CREATE TABLE xbooks
(id NUMBER PRIMARY KEY
, description XMLTYPE);

INSERT INTO xbooks (id,description)
VALUES 
(100,
XMLTYPE('<cover>
<title>Oracle SQL*Loader</title>
<author>Jonathan Gennick</author>
<author>Sanjay Mishra</author>
<pages>269</pages>
</cover>'));

delete from ttest;
insert into ttest (id,vv)
select b.id, EXTRACTVALUE(b.description.EXTRACT('/cover/title'), '/title') xdoc
    from xbooks b;

select id,vv
    from ttest;