create table Supplier(Fnumber int,names nvarchar2(25)) insert into Supplier select 1,'z' from dual union all select 2,'y' from dualcreate table Goods(Fnumber int,SupplierNumber int,names nvarchar2(25)) insert into Goods select 1,1,'ok' from dual union all select 2,2,'no' from dualselect * from Supplier select * from Goods create or replace View supplierGoods as select t1.names as k,t2.names as g from Supplier t1 inner join Goods t2 on t1.Fnumber=t2.suppliernumber; select * from supplierGoods insert into supplierGoods select 'w','okno' from dualdelete from supplierGoods where k='z' 我的删除报错
select * from user_updatable_columns where table_name =视图名称
b:若导出视图的过程中使用分组和聚合操作,也不允许对这个视图执行更新
操作。
c:行列子集视图可执行更新操作。
insert into Supplier
select 1,'z' from dual union all
select 2,'y' from dualcreate table Goods(Fnumber int,SupplierNumber int,names nvarchar2(25))
insert into Goods
select 1,1,'ok' from dual union all
select 2,2,'no' from dualselect * from Supplier
select * from Goods
create or replace View supplierGoods
as
select t1.names as k,t2.names as g from Supplier t1
inner join Goods t2
on t1.Fnumber=t2.suppliernumber;
select * from supplierGoods
insert into supplierGoods
select 'w','okno' from dualdelete from supplierGoods where k='z'
我的删除报错