csv_in_sql: Embed CSV data in SQL
In vh-d/RSQLbuilder: Tools for generating SQL queries from R

Translate a dataset into a plaintext SQL representation

1 2	csv_in_sql(data, tab_name = "tbl", separator = "\|", dialect = "PLSQL", version = c("11g", "10g"))

`data`	dataset to be translated
`tab_name`	name of the resulting "WITH table".
`separator`	specifies string to be used as delimiter in the SQL query (use any character/string that is not present in the data).

Tested with Oracle's PL/SQL.

SQL query as a character value.

1 2	# data(iris) # cat(csv_in_sql(iris))

vh-d/RSQLbuilder documentation built on May 12, 2019, 6:26 p.m.

vh-d/RSQLbuilder index

README.md

Note that we can't provide technical support on individual packages. You should contact the package authors for that.

Description