Python script to extract the content of a table from an Oracle Database to a flat file

extractTable_oracleDB.py

#!/usr/bin/python

import json
import cx_Oracle


tables = ["table1", "table2"]
begin_sql = "SELECT * FROM "
end_sql = " WHERE COL_DATE > sysdate - 1"


con = cx_Oracle.connect('login/[email protected]/orcl')

for table in tables:
	f = open(table + '.extract','w')
	cur = con.cursor()
	cur.arraysize = 2000
	cur.execute(begin_sql + table + end_sql)
	res = cur.fetchall()
	f.write(res)
	cur.close()

con.close