如何从ORACLE中倒出非缺省的XML文件

使用toad工具。
<?xml version = "1.0" ?>
<?xml:stylesheet type="text/xsl" href="dd.xsl"?>
<!DOCTYPE GRID [
  <!ELEMENT GRID (BANDS, COLUMNS, ROWS*)>
  <!ATTLIST GRID ExportVersion CDATA #REQUIRED>
  <!ELEMENT BANDS (BAND*)>
  <!ELEMENT BAND EMPTY>
  <!ATTLIST BAND Index CDATA #REQUIRED>
  <!ATTLIST BAND Caption CDATA #IMPLIED>
  <!ELEMENT COLUMNS (COLUMN*)>
  <!ELEMENT COLUMN EMPTY>
  <!ATTLIST COLUMN Name CDATA #REQUIRED>
  <!ATTLIST COLUMN Caption CDATA #IMPLIED>
  <!ATTLIST COLUMN Index CDATA #REQUIRED>
  <!ATTLIST COLUMN BandIndex CDATA #REQUIRED>
  <!ATTLIST COLUMN RowIndex CDATA #REQUIRED>
  <!ATTLIST COLUMN ColIndex CDATA #REQUIRED>
  <!ATTLIST COLUMN Width CDATA #IMPLIED>
  <!ELEMENT GROUP (GROUP*, ROW*)>
  <!ATTLIST GROUP GroupText CDATA #IMPLIED>
  <!ELEMENT ROWS (ROW*)>
  <!ELEMENT ROW EMPTY>
  <!ATTLIST ROW dbGridColumn1 CDATA #IMPLIED>
  <!ATTLIST ROW dbGridColumn2 CDATA #IMPLIED>
  <!ATTLIST ROW dbGridColumn3 CDATA #IMPLIED>
]>
<GRID ExportVersion="1.0">
  <BANDS>
    <BAND Index="0" Caption=""></BAND>
  </BANDS>
  <COLUMNS>
    <COLUMN Name="dbGridColumn1" Caption="TNAME" Index="0" BandIndex="0" RowIndex="0" ColIndex="0" Width="84"></COLUMN>
    <COLUMN Name="dbGridColumn2" Caption="TABTYPE" Index="1" BandIndex="0" RowIndex="0" ColIndex="1" Width="77"></COLUMN>
    <COLUMN Name="dbGridColumn3" Caption="CLUSTERID" Index="2" BandIndex="0" RowIndex="0" ColIndex="2" Width="90"></COLUMN>
  </COLUMNS>
  <ROWS>
    <ROW dbGridColumn1="CKDM00T" dbGridColumn2="TABLE" dbGridColumn3=""></ROW>
    <ROW dbGridColumn1="XSTWD000" dbGridColumn2="TABLE" dbGridColumn3=""></ROW>
  </ROWS>
</GRID>

解决方案 »

  1.   

    <?xml version="1.0"?>
    <xsl:stylesheet xmlns:xsl="http://www.w3.org/TR/WD-xsl">
      <xsl:template match="/">
        <HTML>
          <BODY>
            <TABLE style="font:10pt MS Sans Serif" border="1" CELLSPACING="0" CELLPADDING="1" BGCOLOR="#FFFFFF">
              <THEAD style="font:bold; background-color:#C0C0C0">
                <TR valign="top">
                  <xsl:for-each select="/GRID/COLUMNS/COLUMN">
                    <TD align="left">
                      <xsl:attribute name="width"><xsl:value-of select="@Width"/></xsl:attribute>
                      <xsl:value-of select="@Caption"/>
                    </TD>
                  </xsl:for-each>
                </TR>
              </THEAD>
              <xsl:for-each select="GRID/ROWS/ROW">
              <TR valign="top">
                <TD align="left">
                  <xsl:value-of select="@dbGridColumn1"/>
                  <xsl:if test="@dbGridColumn1[.='']">&#160;</xsl:if>
                </TD>
                <TD align="left">
                  <xsl:value-of select="@dbGridColumn2"/>
                  <xsl:if test="@dbGridColumn2[.='']">&#160;</xsl:if>
                </TD>
                <TD align="left">
                  <xsl:value-of select="@dbGridColumn3"/>
                  <xsl:if test="@dbGridColumn3[.='']">&#160;</xsl:if>
                </TD>
              </TR>
              </xsl:for-each>
            </TABLE>
          </BODY>
        </HTML>
      </xsl:template>
    </xsl:stylesheet>