6.3 Move Data Between the Database and a Python Session

With OML4Py functions, you can interact with data structures in a database schema.

In your Python session, you can move data to and from the database and create temporary or persistent database tables. The OML4Py functions that perform these actions are described in the following topics.

• About Moving Data Between the Database and a Python Session
• Push Local Python Data to the Database
• Pull Data from the Database to a Local Python Session
• Create a Python Proxy Object for a Database Object
• Create a Persistent Database Table from a Python Data Set

• About Moving Data Between the Database and a Python Session
  Using the functions described in this topic, you can move data between the your local Python session and an Oracle database schema.
• Push Local Python Data to the Database
  Use the oml.push function to push data from your local Python session to a temporary table in your Oracle database schema.
• Pull Data from the Database to a Local Python Session
  Use the pull method of an oml proxy object to create a Python object in your local Python session.
• Create a Python Proxy Object for a Database Object
  Use the oml.sync function to create a Python object as a proxy for a database table, view, or SQL statement.
• Create a Persistent Database Table from a Python Data Set
  Use the oml.create function to create a persistent table in your database schema from data in your Python session.