<SAL>3000</SAL> </ROW> <ROW num=5> <ENAME>FORD</ENAME> <JOB>ANALYST</JOB> <SAL>3000</SAL> </ROW> </ROWSET> </page> The second line of the XSQL file links to an XSLT stylesheet. The XSQL page proces- sor tells the XSLT processor to take the XML and transform it according to the stylesheet. Here is the stylesheet that produces the output that you see in Figure 1.2: <?xml version=1.0?> <xsl:stylesheet version=1.0 xmlns:xsl=http://www.w3.org/1999/XSL/Transform> <xsl:template match=page> <html> <head><title>Simple Stylesheet</title></head> <body> <h1>Employees</h1> <table border=1> <tr bgcolor=#DDDDDD> <td><b>Name</b></td><td><b>Job</b></td><td><b>Salary</b></td> </tr> <xsl:apply-templates select=ROWSET/ROW/> </table> <hr /> </body> </html> </xsl:template> <xsl:template match=ROWSET/ROW> <tr> <td> <xsl:value-of select=ENAME/> </td> <td> <xsl:value-of select=JOB/> </td> <td> <xsl:value-of select=SAL/> </td> </tr> </xsl:template> </xsl:stylesheet> Introducing Oracle XSQL 9 271209 Ch01.F 12/9/02 2:00 PM Page 9
