title: How to get new value (:new.column) while using delete trigger?
body: <p>I am using a delete trigger. I wanted to get both the old value and new value of a particular column in a new table. I tried using <code>:old.columnname</code> and <code>:new.columnname</code>. <code>:old.columnname</code> is working fine, but <code>:new.columnnam</code>e is not working. That column is filled with null in the new table. Is there any workaround for this?</p>