This example describes how Python uses the Cx_oracle module to export data from Oracle to a CSV file. Share to everyone for your reference. The implementation method is as follows:
# 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 = Tr UE # include column headers in each table Outputsql = ' SELECT * from tab ' # get a list of all Tablescurs.execute (SQL) for R Ow_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 ()
Hopefully this article will help you with Python programming.