ORACLE xmltype 遍历

最新推荐文章于 2024-03-21 09:58:05 发布

mno2330

最新推荐文章于 2024-03-21 09:58:05 发布

阅读量626

点赞数

分类专栏：数据库文章标签： Oracle

本文链接：https://blog.csdn.net/mno2330/article/details/83871345

版权

数据库专栏收录该内容

40 篇文章 0 订阅

订阅专栏

DECLARE 
  var       XMLType; 
  doc       DBMS_XMLDOM.DOMDocument; 
  ndoc      DBMS_XMLDOM.DOMNode; 
  docelem   DBMS_XMLDOM.DOMElement;
  nodelist  DBMS_XMLDOM.DOMNodelist;
  node      DBMS_XMLDOM.DOMNode; 
  buf       VARCHAR2(2000);
  v_size    number;

begin 
select PKGPRINTCODES into var   from event_processatlocation where EPL_SYSCODE=142;
  doc    := DBMS_XMLDOM.newDOMDocument(var); 
  ndoc    := DBMS_XMLDOM.makeNode(doc);
  DBMS_XMLDOM.writeToBuffer(ndoc, buf);
  DBMS_OUTPUT.put_line('Before:'||buf);
  
  docelem := DBMS_XMLDOM.getDocumentElement(doc);
  nodelist := DBMS_XMLDOM.getElementsByTagName(docelem, 'PKG_PRINTCODE');

  v_size:=DBMS_XMLDOM.GETLENGTH(nodelist);

  for v in 1..v_size loop
     node := dbms_xmldom.GETFIRSTCHILD(DBMS_XMLDOM.item(nodelist, v-1));
     DBMS_OUTPUT.put_line('aa'||DBMS_XMLDOM.GETNODEVALUE(node));
  end loop;
end;