data pump issue

[SqlHunter]

I want to pump data from table1 of database1 to table 2 of database 2.Here I want to pump the data from table 1 of database1 with criteria as first I have to get the max emp_id and then get the all the records less than that emp_id and then I have to pump the data to the destination and then delete the corressponding dataset from the table 2 of database2.

 

[SqlHunter]

emp_details from database 1

emp_id emp_name process date status
4 john 0 12/12/2004 NEW

5 Raj 0 12/12/2004 NEW

6 Mike 0 12/12/2004 NEW


Database 2

emp_id emp_name process date status
1 Henr 0 12/12/2004 NEW

2 Vinu 0 12/12/2004 NEW

3 AAj 0 12/12/2004 NEW