How to execute SQL statements in R?

In this tutorial, we will be using ROracle which is a R module that enables access to Oracle Database. We will also need to install a DBI module in R which defines an interface for communication between R and relational database management systems. I have updated the installation notes in the bottom of this post to get you setup for using SQL in R.