This is the first video of Database programming with Python. In this video, we will see how to install the cx_Oracle package which is required to connect to the Oracle database.

We will use the command line and perform the installation using the PIP install command. pip is a de facto standard package-management system used to install and manage software packages written in Python. Many packages can be found in the default source for packages and their dependencies — Python Package Index (PyPI).

Most distributions of Python come with pip preinstalled. Python 2.7.9 and later (on the python2 series), and Python 3.4 and later include pip (pip3 for Python 3) by default.

We will also see how to uninstall any package, and how to install any specific version of the package.

We will also see how we can use the requirement.txt file to list all the needed packages and then install all of them with a single pip command.

The cx_Oracle is a Python extension module that enables access to Oracle Database. It conforms to the Python database API 2.0 specification with a considerable number of additions and a couple of exclusions.

cx_Oracle 7 has been tested with Python version 2.7, and with versions 3.5 through 3.8. You can use cx_Oracle with Oracle 11.2, 12, 18 and 19 client libraries. Oracle's standard client-server version interoperability allows connection to both older and newer databases. For example, Oracle 19c client libraries can connect to Oracle Database 11.2.


Links to all videos related to Database programming with Python
=================================================================
1. Install cx_Oracle : [ Ссылка ]
2. Create connection and create table : [ Ссылка ]
3. Insert record into the table with execute() : [ Ссылка ]
4. Insert multiple records into the table with executemany() : [ Ссылка ]
5. Retrive all the data from the table using the fetchall() : [ Ссылка ]
6. Retrive one record from the table using the fetchone() : [ Ссылка ]
7. Retrive specific number of records from the table using the fetchmany() : [ Ссылка ]
8. Use Bind Variables in the select statement to avoid complicating the query with concatenation operation : [ Ссылка ]
9. use callproc method to execute oracle procedure with parameters : [ Ссылка ]
10. use callfunc method to execute oracle function with parameters : [ Ссылка ]

Tools used in creating and executing the scripts:
==================================================
cmd - command prompt
Jupyter Notebook
VSCode - Visual Studio Code


Links used while creating the content:
=======================================
[ Ссылка ]

[ Ссылка ]

[ Ссылка ]


Content and video created by - Kishan Mashru

свернуть