系統函數
更新時間 2025-02-14 10:25:05
最近更新時間: 2025-02-14 10:25:05
分享文章
本頁介紹天翼云TeleDB數據庫Oracle語法中的系統函數。
extract
extract(xmltype類型,節點)。
create table xmlexample(ID varchar(100),name varchar(20),data xmltype);
insert into xmlexample(id,name,data) values('xxxxxxxxxxxxxxx','my document','<?xml version="1.0" encoding="UTF-8" ?>
<collection xmlns="">
<record>
<leader>-----nam0-22-----^^^450-</leader>
<datafield tag="200" ind1="1" ind2=" ">
<subfield code="a">抗震救災</subfield>
<subfield code="f">奧運會</subfield>
</datafield>
<datafield tag="209" ind1=" " ind2=" ">
<subfield code="a">經濟學</subfield>
<subfield code="b">計算機</subfield>
<subfield code="c">10001</subfield>
<subfield code="d">2005-07-09</subfield>
</datafield>
<datafield tag="610" ind1="0" ind2=" ">
<subfield code="a">計算機</subfield>
<subfield code="a">筆記本</subfield>
</datafield>
</record>
</collection>'::xmltype);
teledb=# select id,name, extract(x.data,'/collection/record/datafield/subfield') as A from xmlexample x;
id | name |
a
-----------------+-------------+-----------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------
xxxxxxxxxxxxxxx | my document | <subfield code="a">抗震救災</subfield><subfield code="f">奧運會</subfield><subfield code="a">經濟學</subfield><subfiel
d code="b">計算機</subfield><subfield code="c">10001</subfield><subfield code="d">2005-07-09</subfield><subfield code="a">計算機</subfield><subfield co
de="a">筆記本</subfield>
(1 row)
