Edit D:\app\Administrator\product\11.2.0\dbhome_1\demo\schema\order_entry\empdept.xsl
<?xml version="1.0"?> <html xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xsl:version="1.0" > <!-- This is an example of a single-template stylesheet --> <head><link rel="stylesheet" type="text/css" href="coolcolors.css" /> </head> <body class="page" BGCOLOR="#000000" TEXT="#FFFFCC" LINK="#CCCC00" VLINK="#33FF33"> <center> <P><FONT FACE="Arial, Helvetica, sans-serif"><B><FONT COLOR="#FF0033" SIZE="5">DEPARTMENTS</FONT></B></FONT></P><HR/><P/> <TABLE BORDER="0" CLASS="title" BGCOLOR="#CCCCCC" BORDERCOLOR="#CCCC00" WIDTH="477" HEIGHT="323"> <FONT color="#FF0033"> <B> <tr><td> <center><font color="#FF0033"><b>DEPARTMENT</b></font></center></td> <td> <center><font color="#FF0033"><b>LOCATION </b></font></center></td> <td> <center><font color="#FF0033"><b> EMPLOYEES</b> </font></center></td> </tr> </B> </FONT> <xsl:for-each select="/ROWSET/ROW/Department"><TR><TD WIDTH="6%"> <FONT COLOR="#000000"><B><xsl:value-of select="Name"/> </B></FONT></TD><TD WIDTH="6%"><FONT COLOR="#000000"><B> <xsl:value-of select="Location"/></B></FONT></TD><xsl:choose> <xsl:when test="not(EmployeeList/Employee)"> <TD COLSPAN="3"> <TABLE BORDER="0" WIDTH="100%" CLASS="bl"> <TR> <TD ALIGN="center" WIDTH="100%"><I><B> <FONT COLOR="#000000">No Employees</FONT></B></I> </TD></TR> </TABLE></TD></xsl:when> <xsl:otherwise> <TD WIDTH="53%"> <TABLE BORDER="0" WIDTH="100%" CLASS="b1" BGCOLOR="#9999FF"> <xsl:for-each select="EmployeeList/Employee"> <TR> <TD ALIGN="left"><xsl:value-of select="Name"/></TD><TD ALIGN="right"><xsl:value-of select="Title"/></TD><TD ALIGN="right"><xsl:value-of select="Salary"/></TD><TD ALIGN="right"><xsl:value-of select="StartDate"/></TD></TR> </xsl:for-each> </TABLE></TD></xsl:otherwise> </xsl:choose> </TR> </xsl:for-each> </TABLE></center> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de