Updating table through view in oracle
So here's what I came up with: Thank you for your interest in this question.
Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
proc sql; title 'Current Population Information for Continents'; create view sql.newcontinents as select continent, sum(population) as totpop format=comma15.
An updatable VIEW is one that can have each of its rows associated with exactly one row in an underlying base table.UPDATE Table1 T1 SET T1= (SELECT T2FROM Table2 T2 WHERE T2= T1.id), T1= (SELECT T2FROM Table2 T2 WHERE T2= T1.id) WHERE T1IN (SELECT T2FROM Table2 T2 WHERE T2= T1.id); The full example is here: beef is in having the columns that you want to use as the key in parentheses in the where clause before 'in' and have the select statement with the same column names in parentheses.