diff options
| author | Benjamin Franzke <benjaminfranzke@googlemail.com> | 2013-01-26 18:49:51 +0100 |
|---|---|---|
| committer | Benjamin Franzke <benjaminfranzke@googlemail.com> | 2013-01-26 22:03:06 +0100 |
| commit | df4b7427f6d9fb59bca2d254f13a2fbe2f86ab51 (patch) | |
| tree | af18982b5354d95900749b513f5387a2e8397fa9 /oracle-conversion/rowset-to-sql.xsl | |
| parent | 4eba780ed25ea4fbae8e032dc3510e1c083d0310 (diff) | |
| download | sqltutor-plugin-df4b7427f6d9fb59bca2d254f13a2fbe2f86ab51.tar.gz sqltutor-plugin-df4b7427f6d9fb59bca2d254f13a2fbe2f86ab51.tar.bz2 sqltutor-plugin-df4b7427f6d9fb59bca2d254f13a2fbe2f86ab51.zip | |
begin oracle conversion toolset
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> + |