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


Messages In This Thread
Load data from One oracle Table to Multiple tables - by amy83 - Dec-01-2020, 11:10 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Load data in Oracle muzokh 0 246 Mar-08-2024, 11:19 PM
Last Post: muzokh
  Better python library to create ER Diagram by using pandas data frames as tables klllmmm 0 1,098 Oct-19-2023, 01:01 PM
Last Post: klllmmm
  Using pyodbc&pandas to load a Table data to df tester_V 3 802 Sep-09-2023, 08:55 PM
Last Post: tester_V
Question Using SQLAlchemy, prevent SQLite3 table update by multiple program instances Calab 3 746 Aug-09-2023, 05:51 PM
Last Post: Calab
  extract table from multiple pages sshree43 8 5,264 Dec-12-2022, 10:34 AM
Last Post: arvin
  Load multiple Jason data in one Data Frame vijays3 6 1,536 Aug-12-2022, 05:17 PM
Last Post: vijays3
  panda table data kucingkembar 0 1,117 Mar-01-2022, 10:38 PM
Last Post: kucingkembar
  Sorting table data Blacktime2 1 1,323 Feb-26-2022, 07:05 PM
Last Post: ibreeden
  Migrating data from oracle into postgres python_student 1 2,426 Feb-10-2022, 09:16 PM
Last Post: buran
  Python, how to manage multiple data in list or dictionary with calculations and FIFO Mikeardy 8 2,596 Dec-31-2021, 07:47 AM
Last Post: Mikeardy

Forum Jump:

User Panel Messages

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