A SQL APIs for Oracle R Enterprise

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

The SQL APIs for Oracle R Enterprise are described in the following topics:

SQL Table Functions for Embedded R Execution

• rqEval Function

• rqGroupEval Function

• rqRowEval Function

• rqTableEval Function

PL/SQL Procedures for Managing Datastores and Scripts

• rqDropDataStore Procedure

• rqGrant Procedure

• rqRevoke Procedure

• sys.rqScriptCreate Procedure

• sys.rqScriptDrop Procedure