Python uses CX

This article illustrates how Python uses the Cx_oracle module to export data from Oracle to a CSV file. Share to everyone for your reference. The implementation methods are as follows:

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

> Export Oracle database tables to CSV files # fb36-20 1007117 Import and 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].startswit H (' bin$ '): # Skip Recycle BIN Tables tablename = row_data[0] # Output Each table content to a separate CSV file csv_file_d EST = 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_dat A) outputfile.close ()

I hope this article will help you with your Python programming.