Link to home
Start Free TrialLog in
Avatar of mohammedf
mohammedfFlag 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
ASKER CERTIFIED SOLUTION
Avatar of Muhammad Kashif
Muhammad Kashif
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial