Obviously. If you were talking statement level, you wouldn't even have an ld and :new table. And as was stated, there is practically no other way to do it.

'Practically' means that an impractical solution does exist. That is to create a separate UPDATE trigger for each column (UPDATE of ), but otherwise, ld and :new are your best bet.

I'm wondering what the issue here is. Are there tons of columns? Why do you need to know which ones changed? Why can't the app tell you this? etc.

- Chris