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!

How to take insert statements before deleting

cubeguySep 22 2010 — edited Sep 22 2010
Hi

I've a some requirement here. I need to take the back up of a table before it's data get deleted.

Example

EMP table

If i need to delete the deptno 20 data, before deleting i need to take the back of them as INSERT statements to the UNIX box. could you please guide to do this.i've had heard that this can be done by UTL_FILE package.I'm not sure how to implement this

Thanks
This post has been answered by Saubhik Banerjee on Sep 22 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 20 2010
Added on Sep 22 2010
15 comments
1,374 views