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:
See the reference pages for the functions for more information about them, including examples of their use.