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!

How to hide a record in table from users of different sessions ?

Hariharan STMar 20 2009 — edited Mar 20 2009

Hi,

I am having a table say 'EMPLOYEE' with 10 records in it and users X and Y.

X fetched a row from his session, assume 5th record for perfoming update operation .

Until X commits his transaction , this 5th record should not viewable to user Y evenwith
"SELECT * FROM EMPLOYEE" statement .

How it is possible with oracle ?

Thanx in advance.

Regards,
Hariharan ST

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 17 2009

Added on Mar 20 2009

10 comments

460 views