本文实例讲述了python使用cx_oracle模块将oracle中数据导出到csv文件的方法。分享给大家供大家参考。具体实现方法如下：
# export oracle database tables to csv files
# fb36 – 201007117
import sys
import csv
import cx_oracle
connection = raw_input(“enter oracle db connection (uid/pwd@database) : “)
orcl = cx_oracle.connect(connection)
curs = orcl.cursor()
printheader = true # include column headers in each table output
sql = “select * from tab” # get a list of all tables
curs.execute(sql)
for row_data in curs:
if not row_data[0].startswith(‘bin$’): # skip recycle bin tables
tablename = row_data[0]
# output each table content to a separate csv file
csv_file_dest = tablename + “.csv”
outputfile = open(csv_file_dest,’w’) # ‘wb’
output = csv.writer(outputfile, dialect=’excel’)
sql = “select * from ” + tablename
curs2 = orcl.cursor()
curs2.execute(sql)
if printheader: # add column headers if requested
cols = []
for col in curs2.description:
cols.append(col[0])
output.writerow(cols)
for row_data in curs2: # add table rows
output.writerow(row_data)
outputfile.close()
希望本文所述对大家的python程序设计有所帮助。