Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

materialized view which acts like a session

NaamasJan 20 2013 — edited Jan 21 2013
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 18 2013
Added on Jan 20 2013
12 comments
481 views