3 Replies Latest reply: Jul 9, 2014 11:55 PM by 4997bbec-c4b7-492f-8200-47dd115be3d6 RSS

    Enable prompt before deleting all rows in a table

    4997bbec-c4b7-492f-8200-47dd115be3d6

      Hi All,

       

      Could any one of you please let me know if there is an option in SQL Developer 1.2.0 to enable prompting before deleting all rows in a table. This is to avoid accidental delete when "where" clause is missed out by mistake. If not, is there any other way to achieve this. I know triggers can be set but I am looking for a generic solution on all tables in the database. Please advise. Many thanks.