Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to generate the XML file to HTML?

124220Oct 12 2004 — edited Oct 13 2004
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 10 2004
Added on Oct 12 2004
5 comments
460 views