Python Programming | Connect to an Oracle database from python

Video topic:
00:00 - Intro
00:20 - PEP 249
02:31 - 3 Steps to connect with any database
05:44 - Create location tnand file
06:35 - Import modules
06:54 - Create connection
08:30 - Create Cursor
10:14 - Execute sql

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

[kennethbass]

This was a really good explanation. No extra information, just everything you actually need to know to start writing queries to access your DB from python.

[abhiseksenapati]

Awesome explanation. Just as you need. Keep it up man. Really helpful

[nachinam]

You are doing an amazing job... Please keep up the good work...

[mithunchandra]

Very Very Nice Explanation, Sir. Needs More.

[gajjalanandu]

Hello, it is very helpful keep it up, and can we deploy the .sql scripts (pl/sql and Structure change requiest(SCR) and Data change request(DCR) files) in daily bases into oracle database by using python language.(for automating deployment process). if yes could you suggest the python script or link of website.

[mariogreco]

Kishan, thank you for your excellent content! Just one question: How can I execute a Select From Query and save it in a JSON?

[pratik]

this video is freaking amazing, thanks a lt for this bro

[ashachikodi]

Hello, this was useful, I just wanted to suggest, can u add how can we do the same when we need to put a password to connect to DB.

[jmejias]

Awesome video. Is it possible to pass the connection string from a config. file?

[gayak]

Hi Kishan, thanks for all your good video tutorials, one quick question: i'm not seeing suggestions/IntelliSense with cx_Oracle. This is making me to search for the syntax, any suggestions please?

[nasrullahturke]

What is the difference between driver and connector. Also is there any difference between python libraries for database connection and the odbc driver itself.

[ujwal]

What is the structure of the string you pass into the connection function? In the video you had 'HR/HR@//localhost:1521/orcl" is this

[skipa]

Hi, is it possible to create a script using python to connect to oracle SQL Developer and read a DDL script to a txt file on my pc? if yes, do you have a video on how its done or links to check out?

[NewbieInForeignLand]

Hello Amazing video i must say. Keep coming up with such more content. My one concern is what if i have Cutom JDBC URL, what should i do in that case to get HOST, USERNAME & PASSWORD. Please help

[ABMA]

what if you get message that says: we can't locate the 64 bit oracle client....
I downloaded cx_Oracle package.... I thought it should match directly the operating system running?
Can you please explain how to resolve this issue?

Thanks.
Great lesson and tutorial by the way.
It was very clear and straight forward.

best regards.

[asvlogs]

bhai i need your help related to how to insert stock price in database using cx_oracle

[jaimedpcaus]

How are you able to configure your editor to display the tips after a component and a period (conn.???) Thanks

[bharaths]

This python script is support for all versions or not?

[lavanyau]

In line cur.execute (sql _create) I am getting missing double quotes identifier wt shd I do plz help as soon as possible?

[SonuSingh-snqg]

When I try cur.execute(), there is no method of execute(). What would be the issue ?