troubleshooting Question

Merge oracle data from one table into another

Avatar of mohammedf
mohammedfFlag for Palestine, State of asked on
Oracle Database
2 Comments2 Solutions875 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Muhammad Kashif
Development Manager

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros