blob: 4a2fe05ffb3a6ad61164a7941676b35979905c3d [file] [log] [blame]
create table imv_basetable (a int, b varchar(256), c decimal(10,2));
create materialized view imv_mat_view disable rewrite as select a, b, c from imv_basetable;
insert into imv_mat_view values (1, 'fred', 3.14);