Python uses CX

Source: Internet
Author: User
Tags oracle database

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.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.