Hello everyone, I have been learning about oracle recently. During this process, I have a question regarding the DML operation of views. At first, I thought that being able to query the information of rowid pseudo-columns from a view indicated that this view must be updatable. However, later I found that this was the case for simple single-table views and multi-table join views. However, for more complex multi-table join views, there may be a situation where rowid pseudo-columns can be queried but not updated. I would like to confirm whether there is a connection between them? If there is no association, then what is the significance of the existence of rowid in the view? And in the multi-table join view, does it have similar judgment rules to the key-reserved table?
I hope to receive everyone's help. Thank you very much!