ORACLE EXTRACT()和EXTRACTVALUE() 使用

最新推荐文章于 2024-07-18 17:19:10 发布

myjcwy

最新推荐文章于 2024-07-18 17:19:10 发布

阅读量1.9k

点赞数

文章标签：数据库

本文链接：https://blog.csdn.net/myjcwy/article/details/84044112

版权

drop table t;

create table t(text xmltype);

INSERT INTO t VALUES (XMLType.CreateXML(
'<?xml version="1.0"?>
<fall>
<name>dingjun123</name>
<county>china</county>
<state>xxx</state>
<url>
http://michiganwaterfalls.com/autrain_falls/autrain_falls.html
</url>
</fall>'));

INSERT INTO t VALUES (XMLType.CreateXML(
'<?xml version="1.0"?>
<fall>
<name>jack</name>
<county>china</county>
<state>yyyy</state>
<url>
http://michiganwaterfalls.com/autrain_falls/autrain_falls.html
</url>
</fall>'));
commit;

select extractValue(value(m), '/fall/name') name,
extractValue(value(m), '/fall/county') county,
extractValue(value(m), '/fall/state') state
from t,
table( xmlsequence(extract(t.text,'/fall'))) m ;

参考链接:http://www.itpub.net/thread-1477782-1-1.html