How to generate the XML file to HTML?
124220Oct 12 2004 — edited Oct 13 2004Hi all,
I am new to XML.
Can I somehow see the HTML-Output of the XML-File, when I have the XSL-File too, but don't use any XML-Editor (XMLSpy) and FOP? I do not want use any additional tools - only the database tools.
What I need for this?
Do I need the XSLT-File too?
============================
My test.xml file:
<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="test.xsl"?>
<ROW num="1">
<TABLE_NAME>ABR_ART_ABR_DAU_MATRIX</TABLE_NAME>
<TABLESPACE_NAME>PS2000_STAMM</TABLESPACE_NAME>
<PCT_FREE>10</PCT_FREE>
<INI_TRANS>1</INI_TRANS>
<MAX_TRANS>255</MAX_TRANS>
<INITIAL_EXTENT>516096</INITIAL_EXTENT>
<NEXT_EXTENT>65536</NEXT_EXTENT>
<MIN_EXTENTS>1</MIN_EXTENTS>
<MAX_EXTENTS>2147483645</MAX_EXTENTS>
<PCT_INCREASE>0</PCT_INCREASE>
<LOGGING>YES</LOGGING>
<BACKED_UP>N</BACKED_UP>
<NUM_ROWS>33</NUM_ROWS>
<BLOCKS>20</BLOCKS>
<EMPTY_BLOCKS>0</EMPTY_BLOCKS>
<AVG_SPACE>0</AVG_SPACE>
<CHAIN_CNT>0</CHAIN_CNT>
<AVG_ROW_LEN>100</AVG_ROW_LEN>
<AVG_SPACE_FREELIST_BLOCKS>0</AVG_SPACE_FREELIST_BLOCKS>
<NUM_FREELIST_BLOCKS>0</NUM_FREELIST_BLOCKS>
<DEGREE> 1</DEGREE>
<INSTANCES> 1</INSTANCES>
<CACHE> N</CACHE>
<TABLE_LOCK>ENABLED</TABLE_LOCK>
<SAMPLE_SIZE>33</SAMPLE_SIZE>
<LAST_ANALYZED>1/8/2004 11:45:1</LAST_ANALYZED>
<PARTITIONED>NO</PARTITIONED>
<TEMPORARY>N</TEMPORARY>
<SECONDARY>N</SECONDARY>
<NESTED>NO</NESTED>
<BUFFER_POOL>DEFAULT</BUFFER_POOL>
<ROW_MOVEMENT>DISABLED</ROW_MOVEMENT>
<GLOBAL_STATS>YES</GLOBAL_STATS>
<USER_STATS>NO</USER_STATS>
<SKIP_CORRUPT>DISABLED</SKIP_CORRUPT>
<MONITORING>NO</MONITORING>
<DEPENDENCIES>DISABLED</DEPENDENCIES>
<COMPRESSION>DISABLED</COMPRESSION>
</ROW>
============================
============================
My test.xsl-file:
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fo="http://www.w3.org/1999/XSL/Format">
<xsl:output method="html"/>
<xsl:template match="/">
<html>
<head>
<title>Test XSL ALL_TABLES</title>
</head>
<body>
<xsl:for-each select="ROW">
<h2>Tabelle: <xsl:value-of select="TABLE_NAME"/></h2>
<hr/>
<table border="1" cellpadding="0">
<tr>
<td><xsl:value-of select="TABLESPACE_NAME"/></td>
<td><xsl:value-of select="PCT_FREE"/></td>
</tr>
</table>
</xsl:for-each>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
============================
I am waiting for your answers, when possible with examples please.
Regards
Leonid Pavlov