SQL> create table tsttab(c1 char,c2 char,c3 char);
SQL> create materialized view tstwm as select c1,c3 from tsttab;
SQL> insert into tsttab values ('a','a','a');
SQL> insert into tsttab values ('b','b','b');
SQL> insert into tsttab values ('c','c','c');
SQL> select * from tsttab;
C C C
- - -
a a a
b b b
c c c
SQL> select * from tstwm;
no rows selected
SQL> drop materialized view tstwm;
SQL> create materialized view tstwm as select c1,c3 from tsttab;
SQL> select * from tstwm;
C C
- -
a a
b b
c c
SQL> drop table tsttab;
SQL> select * from tstwm;
C C
- -
a a
b b
c c
SQL> create table tsttab(c1 char,c2 char,c3 char);
SQL> insert into tsttab values ('a','a','a');
SQL> select * from tsttab;
C C C
- - -
a a a
SQL> select * from tstwm;
C C
- -
a a
b b
c c
Partager