The OML4R SQL APIs comprise SQL table functions for executing R functions in one or more embedded R sessions on the OML4R Server database, and PL/SQL procedures for managing OML4R datastores and for managing scripts in the OML4R script repository.

The SQL API for Embedded R Execution with On-premises Database is described in the following topics:

• rqDropDataStore Procedure
  The rqDropDataStore procedure deletes a datastore from an Oracle Database schema.
• rqEval Function
  The rqEval function executes the R function in the script specified by the EXP_NAM parameter.
• rqGrant Procedure
  The rqGrant procedure grants read privilege access to an OML4R datastore or to a script in the OML4R script repository.
• rqGroupEval Function
  The rqGroupEval function is a user-defined function that identifies a grouping column.
• rqRevoke Procedure
  The rqRevoke procedure revokes read privilege access to an OML4R datastore or to a script in the OML4R script repository.
• rqRowEval Function
  The rqRowEval function executes the R function in the script specified by the EXP_NAM parameter.
• rqTableEval Function
  The rqTableEval function executes the R function in the script specified by the EXP_NAM parameter.
• sys.rqScriptCreate Procedure
  The sys.rqScriptCreate procedure creates a script and adds it to the OML4R script repository.
• sys.rqScriptDrop Procedure
  The sys.rqScriptDrop procedure removes a script from the OML4R script repository.