Working With Python and CSV with Oracle Database - Udemy

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