Dec-02-2020, 01:57 AM
Quote:Can you please advise is this possible in Python? If possible please advise the logic.Python is used for many SQL applications.
In fact, most of PgAdmin is written in python.
There are several methods that can be used, from straight SQL Queries (within python) to using SqlAlchemy
(see my tutorial here: https://python-forum.io/Thread-SqlAlchem...-Data-Load )
SqlAlchemy, uses a model and in many instances the model can be shared between DBMS's by simply changing one line, that controls the engine.
Specific to Oracle, you can google 'using python with oracle'
and browse existing packages (that you can install, simply with pip command) here: https://pypi.org/search/?q=oracle&o=