"ORA-01779: 无法修改与非键值保存表对应的列"问题

create table: 

create table student (

 sno number(6) primary key,
 sname varchar2(20),
 deptno char(3)
 ) 
 
 insert into student values (1,'ÕÅÈý','001');
  insert into student values (2,'ÕÅËÄ','002');
 insert into student values (3,'ÕÅÎå','003');
 
 create table department(
 deptno char(3) primary key,
 departname varchar2(20)
 )
 
 insert into department values ('001','ÖÐÎÄ');
 insert into department values ('002','Êýѧ');
 insert into department values ('003','Ó¢Óï');

   

create view:

   create view stu_dep as 
   select s.sno,s.sname,s.deptno deptno1,d.deptno deptno2,d.departname from student s ,department d
   where s.deptno = d.deptno 
   
   
   select * from stu_dep;
   
   update stu_dep set sname = 'jiang' where sno=1;
   
   update stu_dep set deptno2 = '111' where sno=1;
      
 
   
   说明：student 的主键在视图中位主键，则student是键保留表，department 是非键保留表， oracle规定可以更新键保留表 。 eg：可以更新student的数据，不能更新department表。