cx_Oracle获取表列名 分类: database 2014-03-11 12:53 886人阅读 评论(0) 收藏
使用 cursor对象的description获取列名
print cur.description
''' .description
This read-only attribute is a sequence of 7-item sequences.
Each of these sequences contains information describing one result column:
name
type_code
display_size
internal_size
precision
scale
null_ok
'''
结果如下:
![](//img-blog.csdn.net/20140311125055562?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvbXkyMDEwU2Ft/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center)
print cur.description
''' .description
This read-only attribute is a sequence of 7-item sequences.
Each of these sequences contains information describing one result column:
name
type_code
display_size
internal_size
precision
scale
null_ok
'''
#coding:utf-8 import cx_Oracle def main(): conn = cx_Oracle.connect("zebra/zebra@192.168.0.113/benguo") cur = conn.cursor() sql = "select * from userinfo t" result = cur.execute(sql) #获取数据表的列名,并输出 title = [i[0] for i in cur.description] #格式化字符串 g = lambda k:"%-8s" % k title =map(g,title) for i in title: print i, print #输出查询结果 for i in result.fetchmany(5): for k in map(g,i): print k, print if __name__ == '__main__': main()
结果如下: