Updating a join view oracle
01-Sep-2020 19:00
Assuming you're not breaking the rules for updateable views, then you should be okay.
Typically, it does a good job with this, so the update view plan may look very similar to a plan for a simple update to the single affected base table. Then read this blog I wrote recently to see how it could be affected.
However, if you try to query the Oracle VIEW after the table has been dropped, you will receive a message indicating that the Oracle VIEW has errors.
If you recreate the table (the table that you had dropped), the Oracle VIEW will again be fine.
As far as the user is concerned, the view looks just like a table.
Views give you a mechanism for presenting the same data to different users in different ways. As long as both the view and the Customers table are owned by dbo, the permissions granted on the view will take precedence over permissions removed from the Customers table. Because views allow you to restrict the rows and columns that are available, using them as a security tool is very convenient.
So, yes, you can update the data in an Oracle VIEW providing you have the proper privileges to the underlying Oracle tables.