Use of marker in materialized views
Hi all,
I joined as the fresher in the DBA team,i want to create a materialized view by using REFRESH FAST ON COMMIT option, to find the UNION ALL of two queries.
Example i wil show you,
create materialized view mv6
build immediate
refresh fast on commit
enable query rewrite
as
(select d.rowid rid,d.deptno,1 marker from dept d)
union all
(select e.rowid rid,e.deptno,2 marker from emp e);
Iam getting the output, but i am not understanding what is the use of rowid, marker in above example.
Please help me....