Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> extracting xml tag name

extracting xml tag name

From: Shay Toder <shayt_at_fts-soft.com>
Date: Mon, 5 Dec 2005 12:07:29 +0200
Message-ID: <7FF923B77C9A3D46BD808F3BD91473ACF0C8BA@ftsmail.fts-soft.com>


hi,

how can i get the NAME of the XML node,
example -
SELECT EXTRACT (VALUE (e), '/').getstringval () as xml

     , EXTRACTVALUE (VALUE (e), '/') as VALUE
     --, ??? as tag
  FROM TABLE (XMLSEQUENCE (EXTRACT (
       XMLTYPE ('<A>
                    <B>2</B>
                    <C>3</C>
                    <D>4</D>
                </A>'
            ), '/A/*'))) e

the result should be - (the first & second are ok, but how to get the third ?) -

xml

---

<B>2</B>
<C>3</C>
<D>4</D>
value ----- 2 3 4 tag --- B C D Thanks, Shay -- http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 05 2005 - 04:15:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US