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

Home -> Community -> Usenet -> c.d.o.misc -> extracting xml node name

extracting xml node name

From: <shaytemail-ggroups_at_yahoo.com>
Date: 2 Nov 2005 03:34:01 -0800
Message-ID: <1130931241.638012.146910@g49g2000cwa.googlegroups.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
Received on Wed Nov 02 2005 - 05:34:01 CST

Original text of this message

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