1. User's Guide
  2. Embedded R Execution
  3. SQL API for Embedded R Execution with Autonomous Database
  4. Embedded R Execution Functions (Autonomous Database)

9.6.2 Embedded R Execution Functions (Autonomous Database)

The SQL API for Embedded R Execution with Autonomous Database functions are described in the following topics.

  • rqGrant Function
    This topic describes the rqGrant function when used in Oracle Autonomous Database.
  • rqRevoke Procedure
    The rqRevoke procedure revokes read privilege access to an OML4R datastore or to a script in the OML4R script repository.
  • rqListEnvs Function
    The function rqListEnvs when used in Oracle Autonomous Database, lists the environments saved in an Object Storage.
  • rqEval2 Function
    The function rqEval2 when used in Oracle Autonomous Database, runs a user-defined R function that explicitly retrieves data or for which external data is to be automatically loaded for the function.
  • rqTableEval2 Function
    The function rqTableEval2 runs the uer-defined R function in the script specified by the SCR_NAME parameter.
  • rqRowEval2 Function
    The function rqRowEval2 when used in Oracle Autonomous Database,chunks data into sets of rows and then runs a user-defined R function on each chunk.
  • rqGroupEval2 Function
    The function rqGroupEval2 when used in Oracle Autonomous Database, groups data by one or more columns and runs a user-defined R function on each group.
  • rqIndexEval2 Function
    The function rqIndexEval2 when used in Oracle Autonomous Database, runs a user-defined R function multiple times in R engines spawned by the database environment.
  • 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.

Parent topic: SQL API for Embedded R Execution with Autonomous Database