Updating a view in oracle Sexychat
You may wish to update records in one table based on values in another table.Since you can't list more than one table in the Oracle UPDATE statement, you can use the Oracle EXISTS clause.i tried but it shows "missing right parenthesis"please send a reply to my id...thankx.... Hello, when I try this, it gives me the following error: SQL Error: ORA-01779: cannot modify a column which maps to a non key-preserved table01779.
00000 - "virtual column not allowed here" *Cause: *Action: A view is just a stored query -- when you update through it, it's the underlying tables that must be modified.Oracle has no way of knowing what you mean by updating that column. Your view contains a virtual column Actor_Full Name, which is a concatenation of two other real columns.You can only update views that meet certain criteria, or have an associated INSTEAD OF trigger. You are trying to update a view like you would a table."updating primary key related to other foreign key.. Would you like to answer one of these unanswered questions instead?it solved my problem to some i want to know can we update multiple values at the same time using a single querry. Take a look at this example:update ( select profit_bonus, merit_bonus from employee_bonus b inner join employees e on b.employee_id = e.employee_id where e.bonus_eligible = 'N' ) t set t.profit_bonus = 0, t.merit_bonus = 0; Hi David, This time where the employee is eligible for a bonus :-)update ( select b.bonus, e.salary from employee_bonus b inner join employees e on b.employee_id = e.employee_id where e.bonus_eligible = 'Y' ) t set t.bonus = 0.1 * t.salary Hope this helps!
The information displayed by this view is meaningful only for inherently updatable views.