12.7.2 Embedded Python Execution Functions (Autonomous Database)

The SQL API for Embedded Python Execution with Autonomous Database functions are described in the following topics.

Topics

• pyqListEnvs Function (Autonomous Database)
  The function pyqListEnvs when used in Oracle Autonomous Database, lists the environments saved in an Object Storage.
• pyqEval Function (Autonomous Database)
  The function pyqEval, when used in Oracle Autonomous Database, calls a user-defined Python function. Users can pass arguments to the user-defined Python function.
• pyqTableEval Function (Autonomous Database)
  The function pyqTableEval function when used in Oracle Autonomous Database, runs a user-defined Python function on data from an Oracle Database table.
• pyqRowEval Function (Autonomous Database)
  The function pyqRowEval when used in Oracle Autonomous Database, chunks data into sets of rows and then runs a user-defined Python function on each chunk.
• pyqGroupEval Function (Autonomous Database)
  The function pyqGroupEval when used in Oracle Autonomous Database, groups data by one or more columns and runs a user-defined Python function on each group.
• pyqIndexEval Function (Autonomous Database)
  The function pyqIndexEval when used in Oracle Autonomous Database, runs a user-defined Python function multiple times as required in the Python engines spawned by the database environment.
• pyqGrant Function (Autonomous Database)
  This topic describes the pyqGrant function when used in Oracle Autonomous Database.
• pyqRevoke Function (Autonomous Database)
  This topic describes the pyqRevoke function when used in Oracle Autonomous Database.
• pyqScriptCreate Procedure (Autonomous Database)
  This topic describes the pyqScriptCreate procedure in Oracle Autonomous Database. Use the pyqScriptCreate procedure to create a user-defined Python function and add it to the OML4Py script repository.
• pyqScriptDrop Procedure (Autonomous Database)
  This topic describes the pyqScriptDrop procedure in Oracle Autonomous Database. Use the pyqScriptDrop procedure to remove a user-defined Python function from the OML4Py script repository.