Saturday 26 May 2012

Can a view be mutating? If yes, then how? | PL SQL

 No, a view cannot be mutating like a table. If an UPDATE statement fires an INSTEAD OF trigger on a view, the view is not considered to be mutating. If the UPDATE statement had been executed on a table, the table would have been considered as mutating.