cxoracle-query.py

#!/usr/bin/env python
import cx_Oracle

username = "user"
password = "pass"
database = "tnsname"

con = cx_Oracle.connect(username, password, database)
cur = con.cursor()

results = cur.execute("select file_id, encrypted_data from bank_file where disbursement_file_id in (1, 2, 3)")
for row in results:
    disb_file = open("%s_%d" % (database, row[0]), "w")
    disb_file.write(row[1])
    disb_file.close()

cur.close()
con.close()