- 27 Mar, 2022
- 0 Comments
- 1 Min Read
connect to an oracle database using python?
Connect to an oracle database using python?
Step-1:download and install Python for 64-bit Windows
-go to URL: https://www.python.org/downloads/windows/
-scroll down the list until you see Python 2.7.1 – 2010-11-27
-download Windows x86-64 MSI installer (filename: python-2.7.1.amd64.msi)
-go through the installer by accepting all the defaults. The install directory will be C:\Python
-once the installation is complete, add the following locations to the windows PATH variable: C:\Python and C:\Python\Lib\site-packages
-open a command window and launch the python interpreter by running ‘python’ on the command-line prompt
STEP-2: –open a command window and launch the python interpreter by running ‘python’ on the command-line prompt
1 2 3 4 | C:\Users\AHMED>pythonPython 3.10.4 (tags/v3.10.4:9d38120, Mar 23 2022, 23:13:41) [MSC v.1929 64 bit (AMD64)] on win32Type "help", "copyright", "credits" or "license" for more information.>>> |
STEP 3:Install cx_Oracle
1 | python -m pip install cx_Oracle --upgrade --user |
STEP 4:Python Script to connect and Run SQL Query
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | C:\Users\AHMED>pythonPython 3.10.4 (tags/v3.10.4:9d38120, Mar 23 2022, 23:13:41) [MSC v.1929 64 bit (AMD64)] on win32Type "help", "copyright", "credits" or "license" for more information.>>> import cx_Oracle>>> conn = cx_Oracle.connect('username/abc123@xx.xxx.xxx.xx/BATCH47')>>> ver = conn.version.split(".")>>> print(ver)['19', '3', '0', '0', '0']>>> cursor = conn.cursor()>>> query = "select count(*)from student">>> results = cursor.execute(query).fetchall()>>> print(results)[(6,)]>>> conn.close()>>>>>>>>> ^ZC:\Users\AHMED> |
Hope it Helps !