10.5 SQL API for Embedded Python Execution with On-premises Database
SQL API for Embedded Python Execution with On-premises Database has SQL interfaces for Embedded Python Execution and for datastore and script repository management.
The following topics describe the OML4Py SQL interfaces for Embedded Python Execution.
Topics:
- About the SQL API for Embedded Python Execution with On-Premises Database
With the SQL API, you can run user-defined Python functions in one or more separate Python engines in an Oracle database environment, manage user-defined Python functions in the OML4Py script repository, and control access to and get information about datastores and about user-defined Python functions in the script repository. - pyqEval Function (On-Premises Database)
This topic describes thepyqEval
function when used in an on-premises Oracle Database. ThepyqEval
function runs a user-defined Python function that explicitly retrieves data or for which external data is to be automatically loaded for the function. - pyqTableEval Function (On-Premises Database)
This topic describes thepyqTableEval
function when used in an on-premises Oracle Database. ThepyqTableEval
function runs a user-defined Python function on data from an Oracle Database table. - pyqRowEval Function (On-Premises Database)
This topic describes thepyqRowEval
function when used in an on-premises Oracle Database. ThepyqRowEval
function chunks data into sets of rows and then runs a user-defined Python function on each chunk. - pyqGroupEval Function (On-Premises Database)
This topic describes thepyqGroupEval
function when used in an on-premises Oracle Database. ThepyqGroupEval
function groups data by one or more columns and runs a user-defined Python function on each group. - pyqGrant Function (On-Premises Database)
This topic describes thepyqGrant
function when used in an on-premises Oracle Database. - pyqRevoke Function (On-Premises Database)
This topic describes thepyqRevoke
function when used in an on-premises Oracle Database. - pyqScriptCreate Procedure (On-Premises Database)
This topic describes thepyqScriptCreate
procedure in an on-premises Oracle Database. ThepyqScriptCreate
procedure creates a user-defined Python function and adds it to the OML4Py script repository. - pyqScriptDrop Procedure (On-Premises Database)
This topic describes thepyqScriptDrop
procedure in an on-premises Oracle Database. ThepyqScriptDrop
procedure removes a user-defined Python function from the OML4Py script repository.
Parent topic: Embedded Python Execution