Split a single SQL string into one or more SQL statements

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

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

splitSql("SELECT * INTO a FROM b; USE x; DROP TABLE c;")
#> [1] "SELECT * INTO a FROM b" "USE x"                  "DROP TABLE c"