9.6.2 Embedded R Execution Functions (Autonomous AI Database)

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

  • rqGrant Function
    This topic describes the rqGrant function when used in Oracle Autonomous AI 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 AI Database, lists the environments saved in an Object Storage.
  • rqEval2 Function
    The function rqEval2 when used in Oracle Autonomous AI 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 AI 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 AI 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 AI 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 AI Database