Can we connect R and the RStudio IDE to our Oracle Database?

You can connect R (and by extension) the RStudio IDE to an Oracle database.  We recommend looking at our article here for more information:

https://db.rstudio.com/databases/oracle/