• <small id='OQofn'></small><noframes id='OQofn'>

    <i id='OQofn'><tr id='OQofn'><dt id='OQofn'><q id='OQofn'><span id='OQofn'><b id='OQofn'><form id='OQofn'><ins id='OQofn'></ins><ul id='OQofn'></ul><sub id='OQofn'></sub></form><legend id='OQofn'></legend><bdo id='OQofn'><pre id='OQofn'><center id='OQofn'></center></pre></bdo></b><th id='OQofn'></th></span></q></dt></tr></i><div id='OQofn'><tfoot id='OQofn'></tfoot><dl id='OQofn'><fieldset id='OQofn'></fieldset></dl></div>
    <legend id='OQofn'><style id='OQofn'><dir id='OQofn'><q id='OQofn'></q></dir></style></legend>

        <bdo id='OQofn'></bdo><ul id='OQofn'></ul>
    1. <tfoot id='OQofn'></tfoot>

        从 XML 到 Oracle PL/SQL 环境中的路径列表

        From XML to list of paths in Oracle PL/SQL environment(从 XML 到 Oracle PL/SQL 环境中的路径列表)

            <small id='8PZup'></small><noframes id='8PZup'>

              <i id='8PZup'><tr id='8PZup'><dt id='8PZup'><q id='8PZup'><span id='8PZup'><b id='8PZup'><form id='8PZup'><ins id='8PZup'></ins><ul id='8PZup'></ul><sub id='8PZup'></sub></form><legend id='8PZup'></legend><bdo id='8PZup'><pre id='8PZup'><center id='8PZup'></center></pre></bdo></b><th id='8PZup'></th></span></q></dt></tr></i><div id='8PZup'><tfoot id='8PZup'></tfoot><dl id='8PZup'><fieldset id='8PZup'></fieldset></dl></div>
                <tbody id='8PZup'></tbody>
              <legend id='8PZup'><style id='8PZup'><dir id='8PZup'><q id='8PZup'></q></dir></style></legend>

            • <tfoot id='8PZup'></tfoot>
                  <bdo id='8PZup'></bdo><ul id='8PZup'></ul>

                  本文介绍了从 XML 到 Oracle PL/SQL 环境中的路径列表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  请假设您有一个 XML 文件(例如,存储在还有一个 CLOB 列的 Oracle 表中):

                  Please suppose you have a XML file (stored, for example, in an Oracle table which has also a CLOB column):

                  <ALFA>
                    <BETA>0123</BETA>
                    <GAMMA>2345</GAMMA>
                    <DELTA>
                       <EPSILON>3</EPSILON>
                    </DELTA>
                  </ALFA>
                  

                  如何在输出中生成所有可能路径的列表?

                  How can I produce, in output, the list of all possible paths?

                  /ALFA/BETA/text()
                  /ALFA/GAMMA/text()
                  /ALFA/DELTA/EPSILON/text()
                  

                  我的需求如下:我必须从长的 XML 中提取许多信息,并且我必须将 XMLEXTRACT 与所有可能的路径一起使用,所以我想知道是否可以自动dbms_output.put_line"它们方式.

                  My need is the following: I have to EXTRACT many information from a long XML and I have to use XMLEXTRACT with all possible paths, so I would like to know if is it possible to "dbms_output.put_line" them in an automatic way.

                  我需要一个独立于标签名称的解决方案.

                  I need a solution which is independent from the name of the tags.

                  请假设 XML 格式良好.

                  Please suppose that the XML is well-formed.

                  预先感谢您的帮助.

                  • 第二种情况:

                  如果尚未安装 Oracle Java Extension,我该如何继续,并且收到以下错误?

                  How can I proceed if Oracle Java Extension has not been installed, and I receive the following error?

                  ORA-19112: error raised during evaluation:  
                  ORA-06550: line 1, column 13:
                  PLS-00201: identifier 'SYS.DBMS_XQUERYINT' must be declared
                  ORA-06550: line 1, column 7:
                  PL/SQL: Statement ignored
                  

                  请假设我不是 DBA,并且 DBA 不授权安装 Oracle Java Extension.

                  Please suppose that I am not DBA, and DBA don't authorize Oracle Java Extension installation.

                  推荐答案

                  您可以使用 XMLTable 使用 XQuery 生成路径列表.

                  You can use XMLTable to produce list of paths with XQuery.

                  例如

                  (SQLFiddle)

                  with params as (
                    select 
                      xmltype('
                        <ALFA>
                          <BETA>0123</BETA>
                          <GAMMA>2345</GAMMA>
                          <DELTA>
                             <EPSILON>3</EPSILON>
                          </DELTA>
                        </ALFA>
                      ') p_xml
                    from dual  
                  )    
                  select
                    path_name || '/text()'
                  from
                    XMLTable(
                      '
                        for $i in $doc/descendant-or-self::*
                          return <element_path> {$i/string-join(ancestor-or-self::*/name(.), ''/'')} </element_path>
                      '
                      passing (select p_xml from params) as "doc"
                      columns path_name varchar2(4000) path '//element_path'
                    )
                  

                  但这是一种错误的方式,至少因为它并不有效.

                  but it's a wrong way at least because it's not effective as it can.

                  只需使用相同的 XQuery 提取所有值:(SQLFiddle)

                  Just extract all values with same XQuery: (SQLFiddle)

                  with params as (
                    select 
                      xmltype('
                        <ALFA>
                          <BETA>0123</BETA>
                          <GAMMA>2345</GAMMA>
                          <DELTA>
                             <EPSILON>3</EPSILON>
                          </DELTA>
                        </ALFA>
                      ') p_xml
                    from dual  
                  )    
                  select
                    element_path, element_text
                  from
                    XMLTable(
                      '              
                        for $i in $doc/descendant-or-self::*
                          return <element>
                                   <element_path> {$i/string-join(ancestor-or-self::*/name(.), ''/'')} </element_path>
                                   <element_content> {$i/text()}</element_content>
                                 </element>  
                      '
                      passing (select p_xml from params) as "doc"
                      columns 
                        element_path   varchar2(4000) path '//element_path',
                        element_text   varchar2(4000) path '//element_content'
                    )
                  

                  这篇关于从 XML 到 Oracle PL/SQL 环境中的路径列表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益,请联系我们,我们会在确认后第一时间进行删除!

                  相关文档推荐

                  How to call Oracle function or stored procedure using spring persistence framework?(如何使用 Spring 持久化框架调用 Oracle 函数或存储过程?)
                  What can cause intermittent ORA-12519 (TNS: no appropriate handler found) errors(什么会导致间歇性 ORA-12519(TNS:找不到合适的处理程序)错误)
                  SQL to return the number of working days between 2 passed in dates(SQL 返回两个传入日期之间的工作日数)
                  Oracle Date Subtraction(Oracle 日期减法)
                  Is using quot;select *quot; for a cursor in PL/SQL considered bad programming?(正在使用“选择 *PL/SQL 中的游标被认为是糟糕的编程?)
                  Using sql/plsql, how do you find out which character set a text uses?(使用 sql/plsql,你如何找出文本使用的字符集?)
                  • <bdo id='ingYg'></bdo><ul id='ingYg'></ul>

                  • <small id='ingYg'></small><noframes id='ingYg'>

                        <tbody id='ingYg'></tbody>
                          • <i id='ingYg'><tr id='ingYg'><dt id='ingYg'><q id='ingYg'><span id='ingYg'><b id='ingYg'><form id='ingYg'><ins id='ingYg'></ins><ul id='ingYg'></ul><sub id='ingYg'></sub></form><legend id='ingYg'></legend><bdo id='ingYg'><pre id='ingYg'><center id='ingYg'></center></pre></bdo></b><th id='ingYg'></th></span></q></dt></tr></i><div id='ingYg'><tfoot id='ingYg'></tfoot><dl id='ingYg'><fieldset id='ingYg'></fieldset></dl></div>

                            <tfoot id='ingYg'></tfoot><legend id='ingYg'><style id='ingYg'><dir id='ingYg'><q id='ingYg'></q></dir></style></legend>