create table test (N_id number(3),n_name varchar2(10)); insert into test values(10,'ll'); insert into test values(11,'mm'); insert into test values(12,'nn');创建了一个视图 create or replace view testview as select * from test;delete from testview where n_id=10 commit; 原表和视图都变了
insert into test values(10,'ll');
insert into test values(11,'mm');
insert into test values(12,'nn');创建了一个视图
create or replace view testview as select * from test;delete from testview where n_id=10
commit;
原表和视图都变了
只不过是有些限制条件的
比如定义视图的SELECT语句中如果使用了聚合函数就不行