SQL API for Embedded Python Execution with On-premises AI 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.

• 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 AI 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 the pyqEval function when used in an on-premises Oracle AI Database. The pyqEval 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 the pyqTableEval function when used in an on-premises Oracle AI Database. The pyqTableEval function runs a user-defined Python function on data from an Oracle AI Database table.
• pyqRowEval Function (On-Premises Database)
  This topic describes the pyqRowEval function when used in an on-premises Oracle AI Database. The pyqRowEval 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 the pyqGroupEval function when used in an on-premises Oracle AI Database. The pyqGroupEval 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 the pyqGrant function when used in an on-premises Oracle AI Database.
• pyqRevoke Function (On-Premises Database)
  This topic describes the pyqRevoke function when used in an on-premises Oracle AI Database.
• pyqScriptCreate Procedure (On-Premises Database)
  This topic describes the pyqScriptCreate procedure in an on-premises Oracle AI Database. The pyqScriptCreate procedure creates a user-defined Python function and adds it to the OML4Py script repository.
• pyqScriptDrop Procedure (On-Premises Database)
  This topic describes the pyqScriptDrop procedure in an on-premises Oracle AI Database. The pyqScriptDrop procedure removes a user-defined Python function from the OML4Py script repository.