select * from (materialized_v1 union all materialized_v2);
select *
from
(materialized_v1
union all
materialized_v2);
4sup72z81#
你需要 select ，那么 union . 这里没有具体的物化视图：
select
union
select * from materialized_v1 union all select * from materialized_v2;
select * from materialized_v1
select * from materialized_v2;
为此，两个视图的列数相同，数据类型相同。最好是在 select 子句，使您有机会在需要时调整列和数据类型：
select col1, col2, col3 from materialized_v1 union all select col4, col4, col5 from materialized_v2;
select col1, col2, col3 from materialized_v1
select col4, col4, col5 from materialized_v2;
1条答案
按热度按时间4sup72z81#
你需要
select，那么union. 这里没有具体的物化视图：为此，两个视图的列数相同，数据类型相同。最好是在
select子句，使您有机会在需要时调整列和数据类型：