Python Programming | Connect to an Oracle database from python

Опубликовано: 02 Март 2025
на канале: Kishan Mashru

96,048

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
=================================================================
1. Install cx_Oracle :    • Python | How to Install python packages
2. Create connection and create table :    • Python Programming | Connect to an Or...
3. Insert record into the table with execute() :    • Python programming | Insert data into...
4. Insert multiple records into the table with executemany() :    • Python programming | How to insert mu...
5. Retrive all the data from the table using the fetchall() :    • Python programming | Select or get da...
6. Retrive one record from the table using the fetchone() :    • Python programming | Select or get da...
7. Retrive specific number of records from the table using the fetchmany() :    • How to read data from table in python...
8. Use Bind Variables in the select statement to avoid complicating the query with concatenation operation :    • Python programming | Executing SQL qu...
9. use callproc method to execute oracle procedure with parameters :    • Python programming | How to execute O...
10. use callfunc method to execute oracle function with parameters :    • How to execute Oracle Function from P...

Tools used in creating and executing the scripts:
==================================================
VSCode - Visual Studio Code
SQL Developer

Links used while creating the content:
=======================================
https://en.wikipedia.org/wiki/Pip_(pa...)

https://oracle.github.io/python-cx_Or...

https://github.com/oracle/python-cx_O...

Content and video created by - Kishan Mashru