Given an existing database connection and a file containing SQL code, sqlTXT separates the SQL code into single query and submits it sequentially. The results from select are returned as a list of data frames. If comments are in the code, it should only use the form of "--comment" at the beginning of the line. Limitation: Works with RJDBC only for now.
|Package repository||View on GitHub|
Install the latest version of this package by entering the following in R:
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.