InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Can A View Be Mutating? If Yes, Then How? |
|
Answer» 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. 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. |
|