title: Updating a View
body: <p>I have the below view and I am trying to update the view. The error : "virtual column not allowed here" is being displayed. How can I arrange this?</p>
  
  <p>Thanks
  Keith Spiteri</p>
  
  <p>View:</p>
  
  <pre><code>CREATE OR REPLACE VIEW FilmDetailsView
     (Film_Name, Actor_FullName, Hall_Number, Date_Time)
  AS SELECT flm.film_name, actor.actor_name || ' ' || 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 FilmActor filmactor
  ON (flm.film_id = filmactor.filmactor_filmid)
  JOIN Actor actor
  ON (actor.actor_id = filmactor.filmactor_actorid);
  </code></pre>
  
  <p>The Update:</p>
  
  <pre><code>UPDATE FILMDETAILSVIEW
  SET ACTOR_FULLNAME = 'a'
  WHERE HALL_NUMBER = 1;
  </code></pre>
  
  <p>The Error:</p>
  
  <pre><code>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. 00000 -  "virtual column not allowed here"
  *Cause:    
  *Action:
  </code></pre>