oracle plsql:如何解析XML并插入到表中
发布时间:2020-12-12 13:48:49 所属栏目:百科 来源:网络整理
导读:如何将嵌套的xml文件加载到数据库表中? ?xml version="1.0" ? person row nameTom/name Address StateCalifornia/State CityLos angeles/City /Address /row row nameJim/name Address StateCalifornia/State CityLos angeles/City /Address /row/person 在
如何将嵌套的xml文件加载到数据库表中?
<?xml version="1.0" ?> <person> <row> <name>Tom</name> <Address> <State>California</State> <City>Los angeles</City> </Address> </row> <row> <name>Jim</name> <Address> <State>California</State> <City>Los angeles</City> </Address> </row> </person> 在这个xml中,person是表名,name是归档名,Tom是其提交的值. DECLARE x XMLType := XMLType( '<?xml version="1.0" ?> <person> <row> <name>Tom</name> <Address> <State>California</State> <City>Los angeles</City> </Address> </row> <row> <name>Jim</name> <Address> <State>California</State> <City>Los angeles</City> </Address> </row> </person>'); BEGIN FOR r IN ( SELECT ExtractValue(Value(p),'/row/name/text()') as name,ExtractValue(Value(p),'/row/Address/State/text()') as state,'/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; (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |