Row Data
For INSERT
and DELETE
operations, a complete image of the inserted or deleted row is included in the message and all column values are available.
For UPDATE
operations, the complete "before" and "after" images of the row are available, along with a list of column numbers indicating which columns were modified. Access the column values using the names of the columns. The column names in the "before" image all begin with a single underscore. For example, columnname
contains the new value and _columnname
contains the old value.
If the value of a column is NULL
, it is omitted from the column list. The __NULLS
name/value pair contains a semicolon-delimited list of the columns that contain NULL
values.