diff options
Diffstat (limited to 'oracle-conversion/rowset-to-sql.xsl')
-rw-r--r-- | oracle-conversion/rowset-to-sql.xsl | 33 |
1 files changed, 33 insertions, 0 deletions
diff --git a/oracle-conversion/rowset-to-sql.xsl b/oracle-conversion/rowset-to-sql.xsl new file mode 100644 index 0000000..7b2a90a --- /dev/null +++ b/oracle-conversion/rowset-to-sql.xsl @@ -0,0 +1,33 @@ +<?xml version="1.0" encoding="UTF-8"?> +<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> + +<xsl:output method="text"/> + + +<xsl:template match="ROWSET"> + <xsl:text>insert into </xsl:text> + <xsl:value-of select="@NAME"/> + <xsl:text> values</xsl:text> + <xsl:for-each select="ROW"> + <xsl:text> 	(</xsl:text> + <xsl:for-each select="*"> + <xsl:text>'</xsl:text> + <xsl:value-of select="."/> + <xsl:text>'</xsl:text> + <xsl:if test="position() != last()"> + <xsl:text>,</xsl:text> + </xsl:if> + </xsl:for-each> + <xsl:text>)</xsl:text> + <xsl:if test="position() != last()"> + <xsl:text>,</xsl:text> + </xsl:if> + </xsl:for-each> + <xsl:text>; </xsl:text> +</xsl:template> + +<xsl:template match="/"> + <xsl:apply-templates select="DATABASE/ROWSET" /> +</xsl:template> +</xsl:stylesheet> + |