13.7.2 Embedded Python Execution Functions (Autonomous Database)

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

Topics

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