1.建表
create table t(
code varchar(10),
name varchar(20),
id varchar(40) primary key);
2.插入数据:
insert into t(code, name, id) values('001', 'test1', '001');
insert into t(code, name, id) values('002', 'test2', '002');
commit;
3.创建materialized view log
create materialized view log on t with primary key,rowid, sequence (name) including new values;
4.创建materialized view
create materialized view t_mv
build immediate
refresh fast on commit
enable query rewrite
as
select name, id
from t;
5.测试:
update t set name=upper(name);
commit;
select * from t;
select * from t_mv;