Connect to Oracle Database from python with cx_Oracle

connect, fetch, insert, update, delete rows from Oracle database from python using cx_Oracle python module

Please subscribe, like and share this video

00:00 - Intro
00:16 - Install cx_Oracle
00:44 - About Oracle Instant client
01:11 - Database Connection parameters
02:18 - Connect Oracle with sql developer
03:30 - cx_oracle connect to database
06:33 - Create sample table
08:07 - insert rows example
10:56 - parameter substitution
13:36 - executemany
15:01 - delete rows example
19:15 - update rows example
21:37 - fetch rows example
24:38 - convert fetched rows to dataframe
26:59 - Recap
27:20 - Outro

#database #dev #tutorial #learning #beginners #oracle #sqldeveloper #dbeaver #cx_Oracle #taming_python

[andresescamilla]

This video is very complete and thorough. Please keep providing value!

[Imran]

Each content helping me in real time project..👏👏👏

[monilcharola]

You explained every thing very nicely, thank you for the tutorial.

[mithunsaha]

Very Nice Explanation, Sir.Needs More.

[Imran]

Missed to add final part .data frame which is easiest way.. struggled and seeing your video again and it's resolved..don't know what to say this video especially prepared for me to resolve my issues

[rekhajain]

How can I copy data from one oracle database to another for a given table in python script?

[thereawakening]

Hi, Thanks for the amazing video !!
But my question is --
Can't we connect to the oracle db directly with python code before connecting to the db manually through sql-developer first ??

[chicha]

please give the instruction how to setup the connections between pyspark to Autonomous database.

[hungry_khid]

Hello amazing video, quick question. Why do we need python exactly, can we not run sql to edit/query the database normally through oracle? Basically what are the benefits of using a programming language wth sql

[SatyamRai]

Hi, I have Oracle Application running on the cloud and we have a database on cloud environment, Oracle never shares details of database and Oracle Application use that database to store data. How I can import data from Oracle Cloud Database?

[arbaazghameria]

Error for Date/Time operation. As the oracle timestamp cannot be converted to python datetime idk how to remove this error but trunc function somehow seems to work but no good solution found yet

[surendhirankrishnamoorthy]

Have you used Wallet to make the connection secure.

[aanishas]

I have oracle installed on my virtual box, is it enough for me to just change the ipaddress

[pauloribeiro]

In this case, How do to connect DB with SID in Connection String?
my connection worked, but it always gave an ORA-12545 error... But my code worked whenever you want

[devarajmanimaranYT]

Hi Thanks for the video, do you know how to hide the credential and call into python program

[shastransu]

can you make a video how to insert pandas dataframe to oracle database using cx_oracle . i am asking directly inserting whold dataframe to database

[shashanknegi]

Hi, thanks for the video
After executing the code, I am getting error "ORA-01950: no privileges on tablespace 'USERS'"
Can you tell me how to tackle this.
Thanks!

[michelnavarro]

how do you install oracle instant client for mac?

[vheeravk]

Cannot locate a 64-bit oracle client library the specified module could not be found.

Im getting this above error. Can you give me the solution for this one.

[MsRajdutta]

When I am trying to install cx_Oracle, it is saying that it needs Visual C++ 14 or above version but I already have 14.23 version installed. Can you please help me how this issue can be fixed.