6.3 SQL Interface for Embedded R Execution

The SQL interface for Oracle Machine Learning for R 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 OML4R 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 OML4R datastore

Data dictionary views provide information about scripts and datastores.

This SQL interface is described in the following topics:

• About Oracle Machine Learning for R SQL Table Functions
  OML4R provides SQL table functions that are equivalents of most of the R interface functions for embedded R execution.
• Manage Scripts in SQL
  This topic lists the PL/SQL procedures and Oracle Database data dictionary views for creating and managing R scripts.
• Manage Datastores in SQL
  Oracle Machine Learning for R provides PL/SQL procedures and Oracle Database data dictionary views for the basic management of datastores in SQL.