splitSql {SqlRender} | R Documentation |
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 |
Details
This function is needed because some DBMSs (like ORACLE) do not accepts multiple SQL statements being sent as one execution.
Value
A vector of strings, one for each SQL statement
Examples
splitSql("SELECT * INTO a FROM b; USE x; DROP TABLE c;")
[Package SqlRender version 1.18.0 Index]