sql_collapse: Collapse a Multi-line SQL Query
In ds4ci/ds4ciMisc: Miscellaneous Functions for DS4CI Projects
Description
Usage
Arguments
Examples
Description
Collapses a well formatted SQL query such as you would get with
readLines() reading a query created with, say, dbVis into
a single character string. Also any "to end of line" comments are
removed before doing the collapse.
Usage
1
sql_collapse(query)
Arguments
query
string The multi-line SQL query with, perhaps, "–" comments.
Examples
1
2
3
4
5
## Not run:
q <- readLines('./SQL/qVariablesInQueryExample1.sql')
sql_collapse(q)
## End(Not run)
ds4ci/ds4ciMisc documentation built on May 15, 2019, 2:56 p.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Description Usage Arguments Examples
Description
Collapses a well formatted SQL query such as you would get with
readLines() reading a query created with, say, dbVis into
a single character string. Also any "to end of line" comments are
removed before doing the collapse.
Usage
1 | sql_collapse(query)
|
Arguments
query |
string The multi-line SQL query with, perhaps, "–" comments. |
Examples
1 2 3 4 5 | ## Not run:
q <- readLines('./SQL/qVariablesInQueryExample1.sql')
sql_collapse(q)
## End(Not run)
|
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.