FreeLists / oracle-l / extracting xml tag name

["Shay Toder" <shayt@xxxxxxxxxxxx>]

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