cx_Oracle获取表列名

#!/usr/bin/python
# -*- coding: utf-8 -*-
"""
Created on  May 26

@author:Angelevil
"""

#导入模块
import cx_Oracle as co
import sys
import os
import csv
import 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()