Python通过cx_Oracle模块将oracle数据表中的数据导出到csv文件，cx_oraclecsv,# Export Ora

Python通过cx_Oracle模块将oracle数据表中的数据导出到csv文件，cx_oraclecsv,# Export Ora

# Export Oracle database tables to CSV files# FB36 - 201007117import sysimport csvimport cx_Oracleconnection = 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 outputsql = "select * from tab" # get a list of all tablescurs.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()