determine if column has been updated
I'm looking for something similar to the UPDATING() function in MSSQL to determine if a columns has been changed. There are many suggestions to use !=, <=>, IS NULL, IS NOT NULL, but my problem is that i have a nullable column. I need to know if the column is intentionally updated to NULL or if the column hasn't been updated. In both cases the NEW.column is null.
Subject
Views
Written By
Posted
determine if column has been updated
1626
August 11, 2016 11:07PM
866
August 11, 2016 11:57PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.