How to extract DB table data into csv file using python

This is the 11th video of Database programming with Python video tutorial series. In this video we will see how to connect to the Oracle database using the cx_oracle package and extract data using the pandas library.

Steps performed:
================
Create Connection
execute the query using run_sql_query
save the df data onto a csv file

The cx_Oracle is a Python extension module that enables access to Oracle Database. It conforms to the Python database API 2.0 specification with a considerable number of additions and a couple of exclusions.

cx_Oracle 7 has been tested with Python version 2.7, and with versions 3.5 through 3.8. You can use cx_Oracle with Oracle 11.2, 12, 18 and 19 client libraries. Oracle's standard client-server version interoperability allows connection to both older and newer databases. For example Oracle 19c client libraries can connect to Oracle Database 11.2.

Links to all videos related to Database programming with Python
=================================================================

Tools used in creating and executing the scripts:
==================================================
VSCode - Visual Studio Code
SQL Developer

Links used while creating the content:
=======================================

Content and video created by - Kishan Mashru

[stookie]

Thank you Kishan for presenting this practical example. It was very useful and based on your tutorial I managed to source data from the Oracle table.

[allapartheswararaopadyala]

After a long time...Good to see you again

[abbashafedh]

Kishan, you deserve more than respect and appreciation, Your method was so interested and lessons were easily understood. So you have made real favor for us. Can you please complete this very useful series by including videos on how to create forms and reports and full application using python. It would be better if it was real life application. Thanks again, I'm so grateful

[vishnumannepula]

I will share your channel to all my co-workers, your videos are crystal clear

[jeevans]

You are the best man! Your videos are simple, crisp and very easy to understand. Can you please give us a video on how to bind values to pandas sql. I know you have one video on how to bind sql without using pandas, but I need to use pandas for csv file export, and table_name and where_clause will be passed as params in my case.

[krishnamenonkaul]

How can we extract all the tables from a database into CSV format using python. Can you make a video on that or give link to that code. Can you do it asap.

[romainbaillon]

Amazing thanks for the tutorial !! Can you also give us tips to export it as xlsx instead of csv ? Changing the extension doesn't work, it seems a bit more complicated.

[_lonewanderlust_]

Bro do you have any articles to achieve SharePoint connection through python and downloading files from SharePoint?

[jobdossantosleite]

UserWarning: pandas only support SQLAlchemy ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy
warnings.warn(

[vishnumannepula]

Hey Kishan Excellent work by you I just completed watching all your videos for PYTHON.. small request from my end - can you show how to save multiple select queries in one excel as separate sheets ?

[napathelu]

How to send the excel thru mail for other users with a summary like regularly setting up a time

[devarajmanimaranYT]

Hi Kishan, I have a large data inside oracle sql. How do I extract them, this methods I'm following from you is working but taking huge amount of time

[dineshsolanki]

How to process table data as output in json and xml format For each record corresponding column name as tag ?

[shaswatkumar]

Kishan, I'm having 40GB of table size ( billions of records) in Oracle which i wanted to export it to .txt file. Cursor.fetchall() method is failing due to out of memory, also Pandas dataframe is not suitable to hold such large records. Is there any suggestion how to deal with such humongous data. Thank you in advance!

[MrMallesh]

how to transfer big table of 1TB Size into csv

[dipanshumishra]

What to do if I have to fetch multiple tables in different CSV files... from same database..