Python使用cx_Oracle模块将oracle中数据导出到csv文件的方法

本文实例讲述了Python使用cx_Oracle模块将oracle中数据导出到csv文件的方法。分享给大家供大家参考。具体实现方法如下：

    # Export Oracle database tables to CSV files
    # FB36 - 201007117
    import sys
    import csv
    import cx_Oracle
    connection = 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 output
    sql = "select * from tab" # get a list of all tables
    curs.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程序设计有所帮助。