国产一级片,日韩精品,亚洲免费在线视频

本文實例講述了Python使用cx_Oracle模塊將oracle中數(shù)據(jù)導(dǎo)出到csv文件的方法。分享給大家供大家參考。具體實現(xiàn)方法如下：

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