cx_Oracle Module

      cx_Oracle is a Python extension module that allows access to Oracle databases and conforms to the Python database API specification. To use it, you just need to download the version which matches your Oracle client version and python version and setup as the instructions. For Oracle 10g, you need to install the Release 10.2.0.1.0.

 

    1. Connect to a database.

 

    import cx_Oracle

    conn = cx_Oracle.connect('username/password@TNS Name')

 

    2. Execute a sql.

 

    curs = conn.cursor()

    curs.execute(sql)

 

    3. Fetch the result.

 

    curs.fetchall() or curs.fetchone()

 

    4. Excute insert, update.

 

     curs.executmany()

 

More usage, please refer to: http://www.oracle.com/technology/global/cn/pub/articles/devlin-python-oracle.html