6.3.1 About Oracle R Enterprise SQL Table Functions

Oracle R Enterprise provides SQL table functions that are equivalents of most of the R interface functions for embedded R execution. Executing a SELECT FROM TABLE statement and specifying one of the table functions results in the invocation of the specified R script. The script runs in one or more R engines on the Oracle Database server.

The SQL table functions for embedded R execution are:

• rqEval

• rqGroupEval

• rqRowEval

• rqTableEval

The R interface functions and the SQL equivalents are listed in Table 6-1.

For the rqGroupEval function, Oracle R Enterprise provides a generic implementation of the group apply functionality in SQL. You must write a table function that captures the structure of the input cursor.

Some general aspects of the SQL table functions are described in the following topics:

• "Parameters of the SQL Table Functions"

• "Return Value of SQL Table Functions"

• "Connecting to Oracle R Enterprise in Embedded R Execution"

See the reference pages for the functions for more information about them, including examples of their use.