Форум программистов [Powered by Invision Power Board]

Код

Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 
Connected as zloxa@ORCL01
 
SQL> set define off
SQL> select extractValue(xmltype('<params><PHONE>222</PHONE><MPHONE>777</MPHONE><elem1>1</elem1></params>')
  2                        .transform(xmltype('<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  3                                               <xsl:output method="text"/>
  4                                               <xsl:template match="/">
  5                                                 <xsl:for-each select="/*/*">
  6                                                   <xsl:value-of select="name()"/>=<xsl:value-of select="text()"/>
  7                                                   <xsl:choose>
  8                                                     <xsl:when test="position() != last()">&amp;amp;</xsl:when>
  9                                                   </xsl:choose>
 10                                                 </xsl:for-each>
 11                                               </xsl:template>
 12                                             </xsl:stylesheet>
 13                                             '
 14                                           )
 15                                   )
 16                         ,'text()') result
 17  from dual
 18  /
 
RESULT
--------------------------------------------------------------------------------
PHONE=222&MPHONE=777&elem1=1