DETECT AND MOVE DUPLICATE VALUES (2 threads merged by bb) [message #447626] |
Tue, 16 March 2010 20:21  |
luvbondlength
Messages: 1 Registered: March 2010
|
Junior Member |
|
|
Hi i am new to plsql need help. Have to create a procedure to solve the below problem.
Table contains duplicate data . Have to move data to another table. Criteria: check for duplicate values if duplicate exist move all duplicates except one to the history table. While moving to other table see if the record being moved already exists.
source table
SOURCE TABLE : ODS_OWNER
grp_id grp_name face_id address1 city zipcode
3456789 NIKE AERO 457899 707 CROFT GRAND RA 12345
1256789 NIKE AERO CORP 678899 707 CROFT SE GRAND RA 12345
5465455 BB SHIPPING 809708 201 SOUTH CT DESPLAINE 45434
3454534 BB SHIPPING INC 980900 201 SOUTH CT DESPLAINE 45434
2343444 CAT BRAKES 565665 P.O BOX 100 JERSEY 12323
3423423 CAT BRAKES 554645 200 CENTER DR CHICAGO 45645
FIRST 4 RECORDS ARE DUPLICATES FROM WHICH 1 RECORD GOES TO w_grp AND ONE GOES TO HISTORY TABLE. THE RECORD WHICH GOES INTO w_grp OUT OF THE DUPLICATES WILL DEPEND ON THE LAST MODIFIED DATE FOR EACH
DISTINCT VALUES GO IN w_grp TABLE
DUPLICATE GO INTO match_his TABLE
|
|
|
|
|
|