Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CAPTURING THE OUTPUT IN INSERT INTO SELECT AND DELETE

Uday_NSep 23 2010 — edited Sep 23 2010
Hi All,


insert into employee_history_arch select * from employee_history where employee_status = 'CP' and action_dt < (sysdate-32);
commit;

delete from employee_history where employee_status = 'CP' and action_dt < (sysdate-32);
commit;

I have to capture both the output of insert and delete sql query and have to compare both the values for validation. I should not use select count(*) before the delete statement.I shud exactly capture the output..How to do?Please help me
This post has been answered by Saubhik on Sep 23 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 21 2010
Added on Sep 23 2010
#11g, #delete, #insert, #select, #sql
8 comments
3,868 views