xmltype

最新推荐文章于 2021-03-20 16:43:49 发布

iteye_7466

最新推荐文章于 2021-03-20 16:43:49 发布

阅读量90

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/iteye_7466/article/details/82248919

版权

数据库专栏收录该内容

4 篇文章 0 订阅

订阅专栏

Orcale XMlQuery 简记

2010/05/11 20:50

创建表:

CREATE TABLE STXML
(
ID      NUMBER                                NOT NULL,
NAME    VARCHAR2(256 BYTE)                    NOT NULL,
SEX     CHAR(1 BYTE)                          NOT NULL,
AGE     NUMBER                                NOT NULL,
XMLDOC SYS.XMLTYPE
)

查询

                                           SELECT * FROM (
SELECT id,
XMLQUERY(
      'for
$j in /Person
return
<Tr class="tr_moveout">
<td>
        {$j/Id/text()}
        </td>
       <td>
        {$j/Name/text()}
        </td>
        <td>
            {$j/Age/text()}
        </td>
        <td>
        {if ($j/Sex = "1")
       then
        "男"
       else if($j/Sex = "2")
       then
        "女"
       else
         "未知"

       }
        </td>
        </Tr>
    '
PASSING xmldoc RETURNING CONTENT).getStringVal() xcontent FROM stxml
) WHERE xcontent IS NOT NULL;

更新XML节点:

UPDATE stxml medr
set medr.xmldoc = updateXML(medr.xmldoc,'/Person/Name/text()','改改改')
where medr.id = 1;

UPDATE stxml medr
set medr.xmldoc = updateXML(medr.xmldoc,'/Person/Name/text()','更改一下名字',
'/Person/Age/text()',99)
where XMLExists('$p/Person[Age="99"]'
PASSING xmldoc AS "p")

删除XML节点:

UPDATE   stxml
   SET   xmldoc =
            DELETEXML (xmldoc, '/Person/History/Disease/DiseaseItem[DiseaseName="糖尿病"]')
WHERE XMLExists('$p/Person[Name="测试数据"]'
                  PASSING xmldoc AS "p")

iteye_7466

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
xmltype

Orcale XMlQuery 简记2010/05/11 20:50 创建表:CREATE TABLE STXML(ID NUMBER NOT NULL,NAME VARCHAR2(256 BYTE) NOT NULL,SEX CHAR(1 BYTE...
复制链接

扫一扫

专栏目录