R - Sean D. Stuber

Introduction to ASH Data, part 4

2019-02-172020-09-24Sean D. Stuber

What is ASH? AWR and Activity Types Average Active Sessions Graphical Visualizations (this page) Up to this point in my ASH series all of the output was simply rows and columns of data, sometimes augmented with an ascii, text based chart. This time I’ll explore a few different tools to construct better visualizations. One of…

How to pass a vector or data.frame from R to Oracle as a bind variable in a select statement using ROracle.

2017-07-122018-11-10Sean D. Stuber

Recently I was asked how to bind an R variable to a SQL statement executed with ROracle. In this case it wasn’t a simple “select * from table where x = :b1 and y = :b2.” You can do those quite easily with a data.frame with only one row in it using dbGetQuery(connection, sqlstatement, data.frame)…