IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
Hi everyone, today i will show you how to connect Oracle database using python.
Python is very popular and easy to learn programing language. We may need to connect to the database when programming with python. Let’s think simple, just you need import Oracle db package .
import cx_Oracle
Thats all. If you can’t import you need to dowload first. Open ide terminal and
pip install cx_Oracle
Create python file (.py) and add this rows,
conn = cx_Oracle.connect('world/[email protected]/TESTDB')
cursor=conn.cursor()
print (conn.version)
A small code to check that we are connected to the database
Thats all, good luck and see you next article.
Do you want to learn Oracle Database for Beginners, then read the following articles.
https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/
