SqlRender (version 1.6.2)

splitSql: Split a single SQL string into one or more SQL statements

Description

splitSql splits a string containing multiple SQL statements into a vector of SQL statements

Usage

splitSql(sql)

Arguments

sql

The SQL string to split into separate statements

Value

A vector of strings, one for each SQL statement

Details

This function is needed because some DBMSs (like ORACLE) do not accepts multiple SQL statements being sent as one execution.

Examples

# NOT RUN {
splitSql("SELECT * INTO a FROM b; USE x; DROP TABLE c;")

# }