sql_to_rqry: Retrieve SQL query string from .sql files
In afsc-gap-products/coldpool: AFSC/RACE Groundfish Assessment Program EBS and NBS temperature products
sql_to_rqry R Documentation
Retrieve SQL query string from .sql files
Description
This function extracts a query string from simple .sql file. The SQL file should only contain a comment block at the top and the SQL query itself.
Usage
sql_to_rqry(sql_path)
Arguments
sql_path
File path to .sql file as a character vector.
Value
Returns an SQL statement as a character vector, which can be executed on a database connection using functions in the RODBC or ROracle packages.
afsc-gap-products/coldpool documentation built on Sept. 14, 2024, 7:40 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.
| sql_to_rqry | R Documentation |
Retrieve SQL query string from .sql files
Description
This function extracts a query string from simple .sql file. The SQL file should only contain a comment block at the top and the SQL query itself.
Usage
sql_to_rqry(sql_path)
Arguments
sql_path |
File path to .sql file as a character vector. |
Value
Returns an SQL statement as a character vector, which can be executed on a database connection using functions in the RODBC or ROracle packages.
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.