6.3 SQL Interface for Embedded R Execution

The SQL interface for Oracle R Enterprise embedded R execution allows you to execute R functions in production database applications. The SQL interface has procedures for the following actions:

• Adding and removing a script from the Oracle R Enterprise R script repository

• Granting or revoking read privilege access to a script by the owner to other users

• Executing an R script in an embedded R session

• Deleting an Oracle R Enterprise datastore

Data dictionary views provide information about scripts and datastores.

This SQL interface is described in the following topics:

• About Oracle R Enterprise SQL Table Functions

• Manage Scripts in SQL

• Manage Datastores in SQL

• rqEval Function

• rqGroupEval Function

• rqRowEval Function

• rqTableEval Function