1:建立表create table AA(id number,c_cml clob);2:插入欄位insert into aa values(1,to_clob("<PurchaseOrder> <DataElement name="member_id">90558976001</DataElement> <DataElement name="hicn">509488308A</DataElement> <DataElement name="EID">285320</DataElement> </PurchaseOrder>")); 3:查詢select extractvalue(xmltype(c_cml),"/PurchaseOrder/DataElement[@name="member_id"]"), extractvalue(xmltype(c_cml),"/PurchaseOrder/DataElement[@name="hicn"]"), idfrom aa;
1:建立表create table AA(id number,c_cml clob);2:插入欄位insert into aa values(1,to_clob("<PurchaseOrder> <DataElement name="member_id">90558976001</DataElement> <DataElement name="hicn">509488308A</DataElement> <DataElement name="EID">285320</DataElement> </PurchaseOrder>")); 3:查詢select extractvalue(xmltype(c_cml),"/PurchaseOrder/DataElement[@name="member_id"]"), extractvalue(xmltype(c_cml),"/PurchaseOrder/DataElement[@name="hicn"]"), idfrom aa;