Ask the Expert

Can I mark a record as deleted in Oracle?

Is it possible to mark a record as deleted? I have to reuse the deleted record. If possible explain.

    Requires Free Membership to View

Once the record is deleted with the DELETE command, you cannot easily reuse the record. If you need to reuse this data, then it should not be deleted. The trick typically employed here is to add another column to the table called ACTIVE. This column will contain a "Y" (yes) if this is an active record or an "N" (no) if the record is no longer active. However, the record still exists in the table. It is not deleted.

This was first published in August 2007

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.