Skip to Main Content

Oracle Database Discussions

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!

Block delete of records

David PulliamJul 2 2007 — edited Jul 2 2007
Is there any way to use a trigger to block deletion of records?

In a table I am working with, it has several special records that I would like to basically have a field that would mark them as no delete on trunc or by query. Is there any way to handle this?

Thanks,
David Pulliam
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 30 2007
Added on Jul 2 2007
8 comments
973 views