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
    '''

#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()

结果如下：