第1个回答 2011-08-27
BEGIN
BEGIN
insert into #temp select T1.id from T1,T2 where T1.id=T2.id;
DELETE from T1 WHERE id IN (select id from #temp);
DELETE from T2 WHERE id IN (select id from #temp);
drop table #temp;
EXCEPTION
WHEN NO_DATA_FOUND THEN
DBMS_OUTPUT.PUT_LINE('Employee Number Not Found!');
END
COMMIT;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
END;
/