CREATE VIEW - Oracle Documentation

If you want a join view to be updatable, then all of the following conditions must be true: ... A key-preserved table is one for which every primary key or unique key value in the base table is also unique in the join view. For an UPDATE statement, the vi

docs.oracle.com