3.3  6 reviews on Udemy

Working With Python and CSV with Oracle Database

Export Data from CSV and Import into Oracle Table
Course from Udemy
 27 students enrolled
 en
Learn about how to Handle CSV file to Extract data and Import into Oracle DB

I knew it wouldn't take much code to do this, but there was still a little fiddling around and some odd errors along the way. Anyhow if you want to do this here is some helpful tips

Firstly download the latest stable version of Python. Next download and install the cx_Oracle extension, from Oracle official website. You will then need to download and install the Oracle Client ensuring you select the version specific to your installation ie. 10g or 11g etc. You can get the download from here Oracle software downloads.

Make sure that you have the ORACLE_HOME variable set and the bin is in your PATH variable, otherwise you will get cx_Oracle DLL load failure messages.

If you have a fairly, long complex SQL statement then encase the query within triple single quotes. It works a treat and takes care of new lines without need for you to do any formatting or

string manipulation. Lets Start

Note : This Course explicitly for working with CSV, Python and Oracle .


Good Luck !!!


Thanks,

Arun Ammasai

Working With Python and CSV with Oracle Database
$ 19.99
per course
Also check at

FAQs About "Working With Python and CSV with Oracle Database"

About

Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.
DISCLOSURE: This page may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

SOCIAL NETWORK