oracle解析表中xml,oracle plsql：如何解析XML并插入到表中

您可以将XML文档加载到XMLType中,然后查询它,例如：

DECLARE

x XMLType := XMLType(

'<?xml version="1.0" ?>

Tom

California

Los angeles

Jim

California

Los angeles

');

BEGIN

FOR r IN (

SELECT ExtractValue(Value(p),'/row/name/text()') as name

,ExtractValue(Value(p),'/row/Address/State/text()') as state

,ExtractValue(Value(p),'/row/Address/City/text()') as city

FROM TABLE(XMLSequence(Extract(x,'/person/row'))) p

) LOOP

-- do whatever you want with r.name, r.state, r.city

END LOOP;

END;