Python Forum
Load data from One oracle Table to Multiple tables
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Load data from One oracle Table to Multiple tables
#1
Hi Experts,
I am in process of learning Python. I am Oracle Developer. I have one source table with Multiple columns. There are several Target tables. I am interested on load data from Source file to Target tables ( need to do all the validations like compare the matched columns data if matched then UPDATE else need to INSERT the data into the table. Need to this validation for all the tables. And would like to automate this process.
Can you please advise is this possible in Python? If possible please advise the logic.

Thanks
Amy.
Reply
#2
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=
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  API Gateway to manage multiple API's get put data robsuttonjr 2 239 Mar-09-2021, 04:09 PM
Last Post: robsuttonjr
  Pandas: how to split one row of data to multiple rows and columns in Python GerardMoussendo 4 388 Feb-22-2021, 06:51 PM
Last Post: eddywinch82
  Yahoo_fin, Pandas: how to convert data table structure in csv file detlefschmitt 14 921 Feb-15-2021, 12:58 PM
Last Post: detlefschmitt
  How to filter out Column data From Multiple rows data? firaki12345 10 629 Feb-06-2021, 04:54 AM
Last Post: buran
  Python script to summarize excel tables, then output a composite table? i'm a total n surfer349 1 207 Feb-05-2021, 04:37 PM
Last Post: nilamo
  Data extraction from a table based on column and row names tgottsc1 1 428 Jan-09-2021, 10:04 PM
Last Post: buran
  Fetching data from multiple tables in a single request. swaroop 0 203 Jan-09-2021, 04:23 PM
Last Post: swaroop
  How to fill parameter with data from multiple columns CSV file greenpine 1 225 Dec-21-2020, 06:50 PM
Last Post: Larz60+
  I try to import data from Excel table to Word Template. NewbiePyPy 0 386 Oct-21-2020, 12:25 PM
Last Post: NewbiePyPy
  How to use subprocess to get multiple data outputs in desired folder? 3SG14 1 493 Sep-19-2020, 05:46 PM
Last Post: bowlofred

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020