本文实例讲述了python使用cx_oracle模块将oracle中数据导出到csv文件的方法。分享给大家供大家参考。具体实现方法如下：
# export oracle database tables to csv files# fb36 - 201007117import sysimport csvimport cx_oracleconnection = 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 outputsql = select * from tab # get a list of all tablescurs.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程序设计有所帮助。