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
  extract table from multiple pages sshree43 8 1,193 Dec-12-2022, 10:34 AM
Last Post: arvin
  Load multiple Jason data in one Data Frame vijays3 6 646 Aug-12-2022, 05:17 PM
Last Post: vijays3
  panda table data kucingkembar 0 572 Mar-01-2022, 10:38 PM
Last Post: kucingkembar
  Sorting table data Blacktime2 1 770 Feb-26-2022, 07:05 PM
Last Post: ibreeden
  Migrating data from oracle into postgres python_student 1 1,116 Feb-10-2022, 09:16 PM
Last Post: buran
  Strategy on updating edits back to data table and object variables hammer 0 766 Dec-11-2021, 02:58 PM
Last Post: hammer
  SQLALCHEMY - Not selecting data from table jamesaarr 4 1,409 Nov-02-2021, 03:02 PM
Last Post: Larz60+
  Extracting Data from tables DataExtrator 0 771 Nov-02-2021, 12:24 PM
Last Post: DataExtrator
  How to map two data frames based on multiple condition SriRajesh 0 984 Oct-27-2021, 02:43 PM
Last Post: SriRajesh
  Slittping table into Multiple tables by rows drunkenneo 1 1,160 Oct-06-2021, 03:17 PM
Last Post: snippsat

Forum Jump:

User Panel Messages

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