1. User's Guide
  2. SQL APIs for Oracle Machine Learning for R

A SQL APIs for Oracle Machine Learning for R

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 APIs for OML4R are 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.