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)
sql |
The SQL string to split into separate statements |
This function is needed because some DBMSs (like ORACLE) do not accepts multiple SQL statements being sent as one execution.
A vector of strings, one for each SQL statement
splitSql("SELECT * INTO a FROM b; USE x; DROP TABLE c;")Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.