-- 1. Create table.
create table peoples(
 people_id number(3),
 people_spec sys.xmltype);

--2. Insert data

insert into peoples
values(8,
sys.xmltype.createxml('<?xml version="1.0"?>
<people>
 <name>Fuju</name>
 <loc>BKK</loc>
 <tel>272739</tel>
 <email>fuju@exzilla.net</email>
</people>
')
);

insert into peoples
values(9,
sys.xmltype.createxml('<?xml version="1.0"?>
<people>
 <name>Teddy</name>
 <loc>UK</loc>
 <tel>272449</tel>
 <email>teddy@exzilla.net</email>
</people>
')
);

-- 3.Qeury Data
select 
p.people_id,
p.people_spec.extract('/people/name/text()').getStringVal() "Name"
from peoples p;

-- 4. Update Data
update peoples set people_spec =
sys.XMLType.createxml('<?xml version="1.0"?>
<people>
 <name>Teera</name>
 <loc>UK</loc>
 <tel>272449</tel>
 <email>teddy@exzilla.net</email>
</people>
') 
where people_id=9;

-- 4. Delete Data
delete from peoples p 
where 
p.people_spec.extract('/people/name/text()').getStringVal() 
= 'Teera';