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!

Use a trigger to mark row as deleted using a flag instead of actually deleting the row

M.EmmanuelAug 14 2016 — edited Aug 17 2016

I would like to mark deleted rows as deleted using a flag instead of actually removing them from database.

I would like to use a trigger so I do not have to care about that in the application layer.

pastedImage_0.png

And

pastedImage_1.png

But what should I do to specify that the row should not be deleted?

I am using Oracle 11g XE
This post has been answered by BluShadow on Aug 15 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 14 2016
Added on Aug 14 2016
#delete, #trigger
17 comments
5,690 views