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

In SqlRender: Rendering Parameterized SQL and Translation to Dialects

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;")

SqlRender documentation built on Oct. 9, 2024, 9:07 a.m.