Avatar of mohammedf
mohammedf
Flag for Palestine, State of asked on

Merge oracle data from one table into another

Hi Experts
i have to following system ...
i have "Employee Management System" , part of this system is attendance time, this means that i have an external elcotoric clock , and the employee put his number ,, and it stores the time of arriving and leaving automaticlay in table called "COLLECT_EMPLOYEE" .. so each employee has two recoreds each day ,, one for arriving ,, and other for leaving work,,,,

now there is another table called "ADM_WORK_FOLW_TB" , this table is much organized  than the "COLLECT_EMPLOYEE"  as ""COLLECT_EMPLOYEE" " is form the clock ,, and i can not modify its structure...
any way here is what i want ...
i want to make a procedure that copy the data from the "COLLECT_EMPLOYEE"  table and insert it into the second table , so i want to put 2 records form the  "COLLECT_EMPLOYEE"  into one record in the second table ,,,,  this to make each record to represnt daily movment for each employee instead of makeing 2 records for each employee in "COLLECT_EMPLOYEE" ...

hope this is clear ...
Many thanks in advance..
attaced the DDL for two tables
and two images for table data and how it suppoed to be

thanks
DDL.txt
collect-employee.JPG
adm-work-follow-tb.jpg
Oracle Database

Avatar of undefined
Last Comment
Naveen Kumar

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Muhammad Kashif

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Naveen Kumar

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes