Updating an oracle view


05-Nov-2019 15:15

How can you update a view column that is generated through a combination of multiple base columns? And how can it update either or both in a way that will behave correctly after the update, given that the expression for the virtual column always includes a space?

The ACTOR_FULLNAME column in the view is a concatenation of two base columns and a literal. If you have some meaningful logic you want to implement to handle such an UPDATE, you could use an INSTEAD OF trigger on the view to implement it.

The view consist of a one really big table (fact) and another inline view joined together.

updating an oracle view-25

adult dating services carson city nevada

actor.actor_surname, hall.cinemahall_number, schedule.schedule_date FROM film flm JOIN movieschedule schedule ON (flm.film_id = schedule.schedule_filmid) JOIN cinemahall hall ON (schedule.schedule_hallid = hall.cinemahall_id) JOIN Film Actor filmactor ON (flm.film_id = filmactor.filmactor_filmid) JOIN Actor actor ON (actor.actor_id = filmactor.filmactor_actorid); Error starting at line 312 in command: UPDATE FILMDETAILSVIEW SET ACTOR_FULLNAME = 'a' WHERE HALL_NUMBER = 1 Error at Command Line:313 Column:4 Error report: SQL Error: ORA-01733: virtual column not allowed here 01733.