I have 3 employee tables with employee_name as Primary Key.
The table structures are as follows.
1) desc employee_info
DOB Date, sex Varchar2(10),
2) desc employee_pay
3) desc employee_location
I need a pl\sql scripts for
a) to delete the employee records from the above 3 tables
who resigned on or earlier to Feb 1st (<= 02/01/2012)
b) script for the above requirement with deleted records
storing in temprary tables.