create table AA(id number,c_cml clob);
2:插入字段
insert into aa values(1,to_clob('
3:查询
select extractvalue(xmltype(c_cml),'/PurchaseOrder/DataElement[@name="member_id"]'),
extractvalue(xmltype(c_cml),'/PurchaseOrder/DataElement[@name="hicn"]'),
id
from aa;