SQL> select * from ii;
N V
---------- --------
1 a
2 b
3 c
SQL> alter table ii add constraint ii_p primary key(n);
Table altered.
SQL> create materialized view v_ii refresh force on commit as select * from ii;
Materialized view created.
SQL>
N V
---------- --------
1 a
2 b
3 c
SQL> alter table ii add constraint ii_p primary key(n);
Table altered.
SQL> create materialized view v_ii refresh force on commit as select * from ii;
Materialized view created.
SQL>
本文详细介绍了如何使用SQL进行表操作,包括添加主键约束和创建Materialized View,并展示了刷新视图的过程。
3450

被折叠的 条评论
为什么被折叠?



