Hi all .
Is there a way to create mview that acts like a session? i'll explain :
i'm connecting to a session (let's call this session , session 1 )
sqlplus naama/naama@passwd
select emp_id , emp_name from emp;
emp_id emp_name
----------- -----------------
1 Naama
2 Alice
3 Alexandra
update emp set emp_name = 'ROY' where emp_id = 1 ;
select emp_id , emp_name from emp;
emp_id emp_name
----------- -----------------
1 ROY
2 Alice
3 Alexandra
Because i'm in the same session , when i'm doing an update , without a commit i will still see the data after the update (=ROY and not Naama ) .
Is there Any mview that i can declare that will be refreshed when i'm making a changes to the base table , means mview that will acts as if it was a select
inside the same session ,
Please Your Help
Naama