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

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