#!/usr/bin/python# -*- coding: utf-8 -*- """Created on May 26 @author:Angelevil"""#导入模块import cx_Oracle as coimport sys import osimport csvimport traceback# 连接数据库ORCL = co.connect('dbuser/dbpwd@ip_address:port/TNS')#创建游标CURS = ORCL.cursor()#编写SQL语句SQL = "select * from table_name"#执行SQL语句curs = CURS.execute(SQL)#查看数据库数据data = curs.fetchall()# print(data)#获取表的列名title = [i[0] for i in CURS.description]#将数据写入CSV文件try: with open("table_name.csv",'w') as csvfile: writer = csv.writer(csvfile) writer.writerow(title) writer.writerows(data)except: print("文件写入数据错误")finally: finally : CURS.close() ORCL.close()