Blog
connect to an oracle database using python?
- March 27, 2022
- Posted by: Ankush Thavali
- Category: Uncategorized
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
C:\Users\AHMED>python Python 3.10.4 (tags/v3.10.4:9d38120, Mar 23 2022, 23:13:41) [MSC v.1929 64 bit (AMD64)] on win32 Type "help", "copyright", "credits" or "license" for more information. >>>
STEP 3:Install cx_Oracle
python -m pip install cx_Oracle --upgrade --user
STEP 4:Python Script to connect and Run SQL Query
C:\Users\AHMED>python Python 3.10.4 (tags/v3.10.4:9d38120, Mar 23 2022, 23:13:41) [MSC v.1929 64 bit (AMD64)] on win32 Type "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() >>> >>> >>> ^Z C:\Users\AHMED>
Hope it Helps !
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
C:\Users\AHMED>python Python 3.10.4 (tags/v3.10.4:9d38120, Mar 23 2022, 23:13:41) [MSC v.1929 64 bit (AMD64)] on win32 Type "help", "copyright", "credits" or "license" for more information. >>>
STEP 3:Install cx_Oracle
python -m pip install cx_Oracle --upgrade --user
STEP 4:Python Script to connect and Run SQL Query
C:\Users\AHMED>python Python 3.10.4 (tags/v3.10.4:9d38120, Mar 23 2022, 23:13:41) [MSC v.1929 64 bit (AMD64)] on win32 Type "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() >>> >>> >>> ^Z C:\Users\AHMED>
Hope it Helps !